Skip site navigation (1) Skip section navigation (2)

AW: Query Planning time increased 3 times on 7.1 compared to 7.0.3

From: Zeugswetter Andreas SB <ZeugswetterA(at)wien(dot)spardat(dot)at>
To: "'christof(at)petig-baender(dot)de'" <christof(at)petig-baender(dot)de>, PostgreSQL Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: AW: Query Planning time increased 3 times on 7.1 compared to 7.0.3
Date: 2001-03-05 15:18:35
Message-ID: 11C1E6749A55D411A9670001FA687963368221@sdexcsrv1.f000.d0188.sd.spardat.at (view raw or flat)
Thread:
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 

Responses

pgsql-hackers by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group