Re: Performance problem on 2 PG versions on same query

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Tomas Vondra" <tv(at)fuzzy(dot)cz>
Cc: "Rémy-Christophe Schermesser" <rcs(at)netcosports(dot)com>, pgsql-general(at)postgresql(dot)org, "Bertrand Paquet" <bertrand(at)netcosports(dot)com>
Subject: Re: Performance problem on 2 PG versions on same query
Date: 2014-11-05 17:30:04
Message-ID: 13858.1415208604@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

"Tomas Vondra" <tv(at)fuzzy(dot)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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Jon Erdman 2014-11-05 23:01:29 PLV8 and JS exports / referencing
Previous Message Tomas Vondra 2014-11-05 17:17:14 Re: Performance problem on 2 PG versions on same query