Christoph Berg <christoph.berg@xxxxxxxxxxx> 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 -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
