> 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 ?
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