AW: Query Planning time increased 3 times on 7.1 compar ed to 7.0.3
Zeugswetter Andreas SB <zeugswettera@wien.spardat.at>
From: Zeugswetter Andreas SB <ZeugswetterA@wien.spardat.at>
To: "'christof@petig-baender.de'" <christof@petig-baender.de>, PostgreSQL Hackers <pgsql-hackers@postgresql.org>
Date: 2001-03-05T15:18:35Z
Lists: pgsql-hackers
> Here is one of the queries, it takes about half a second on our computer > (PII 233 with 256MB RAM) to execute and returns typically 1-4 rows via > two index scans with high selectivity. So it looks to me that planning > time outwages execution time by far. 7.0 took about 0.15 > seconds (which is still much). The plans show two different indexes and different statistics for the two different versions. No wonder, you see different response times. Is the "vacuum [analyze]" up to date in both versions ? Andreas