Re: Performance problem on 2 PG versions on same query

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Performance problem on 2 PG versions on same query
Дата
Msg-id 13858.1415208604@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Performance problem on 2 PG versions on same query  ("Tomas Vondra" <tv@fuzzy.cz>)
Ответы Re: Performance problem on 2 PG versions on same query  (Rémy-Christophe Schermesser <rcs@netcosports.com>)
Список pgsql-general
"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 по дате отправления:

Предыдущее
От: "Tomas Vondra"
Дата:
Сообщение: Re: Performance problem on 2 PG versions on same query
Следующее
От: Jon Erdman
Дата:
Сообщение: PLV8 and JS exports / referencing