AW: Query Planning time increased 3 times on 7.1 compar ed 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 compar ed to 7.0.3
Date: 2001-03-05 15:18:35
Message-ID: 11C1E6749A55D411A9670001FA687963368221@sdexcsrv1.f000.d0188.sd.spardat.at
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse pgsql-hackers by date

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