> 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 

Responses

• Re: Query Planning time increased 3 times on 7.1 compared to 7.0.3 at 2001-03-05 22:17:24 from Christof Petig

pgsql-hackers by date

Next:	From: Tom Lane	Date: 2001-03-05 15:51:44
	Subject: Re: Oops! Its bug in parser????
Previous:	From: Christof Petig	Date: 2001-03-05 15:07:04
	Subject: Re: Query Planning time increased 3 times on 7.1 compared to 7.0.3