Postgres Pro
Downloads
Home   >   mailing lists

Re: Performance problem on 2 PG versions on same query - Mailing list pgsql-general

From Tom Lane
Subject Re: Performance problem on 2 PG versions on same query
Date
Msg-id 13858.1415208604@sss.pgh.pa.us
Whole thread Raw
In response to Re: Performance problem on 2 PG versions on same query  ("Tomas Vondra" <tv@fuzzy.cz>)
Responses Re: Performance problem on 2 PG versions on same query
List pgsql-general
Tree view 
"Tomas Vondra" <tv@fuzzy.cz> writes:
> Dne 5 Listopad 2014, 18:10, Tom Lane napsal(a):
>> For some reason there's over 1000 times more rows in andalertsmatch in
>> the 9.1.14 installation.  I'm betting on a foulup somewhere in the data
>> dump/restore process.

> I'd bet that's mostly due to rescans in the merge join ...

Doh, I should have thought of that :-(.  But still, the difference in
the number of final output rows is pretty compelling evidence that
it's not really the same data.

            regards, tom lane

pgsql-general by date:

Previous
From: "Tomas Vondra"
Date:
Subject: Re: Performance problem on 2 PG versions on same query
Next
From: Jon Erdman
Date:
Subject: PLV8 and JS exports / referencing