Re: RT3.4 query needed a lot more tuning with 9.2 than it did with 8.1

От: Tom Lane
Тема: Re: RT3.4 query needed a lot more tuning with 9.2 than it did with 8.1
Дата: ,
Msg-id: 1583.1367858328@sss.pgh.pa.us
(см: обсуждение, исходный текст)
Ответ на: RT3.4 query needed a lot more tuning with 9.2 than it did with 8.1  (Christoph Berg)
Ответы: Re: RT3.4 query needed a lot more tuning with 9.2 than it did with 8.1  (Christoph Berg)
Список: pgsql-performance


Christoph Berg <> writes:
> We recently (finally) migrated an Request Tracker 3.4 database running
> on 8.1.19 to 9.2.4. The queries used by rt3.4 are sometimes weird, but
> 8.1 coped without too much tuning. The schema looks like this:

The newer rowcount estimates are much further away from reality:

>  Unique  (cost=1117.67..1118.46 rows=9 width=1115) (actual time=82.646..85.695 rows=439 loops=1)

>  Unique  (cost=784205.94..796940.08 rows=145533 width=1061) (actual time=9710.683..9713.175 rows=439 loops=1)

Has the new DB been analyzed?  Maybe you had custom stats targets in
the old DB that didn't get copied to the new one?

            regards, tom lane



В списке pgsql-performance по дате сообщения:

От: Gavin Flower
Дата:
Сообщение: Re: Deterioration in performance when query executed in multi threads
От: mark.kirkwood@catalyst.net.nz
Дата:
Сообщение: Re: In progress INSERT wrecks plans on table