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