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

Query performance. 7.2.3 Vs. 7.3

From: wade <wade(at)wavefire(dot)com>
To: pgsql-hackers(at)postgresql(dot)org
Subject: Query performance. 7.2.3 Vs. 7.3
Date: 2002-11-29 01:04:37
Message-ID: 3.0.32.20021128170437.015d7b20@mail.wavefire.com (view raw or flat)
Thread:
Lists: pgsql-hackers
  While playing with one of my DBs under 7.3 to make use of its better
explain features, I came across a query that runs significantly slower
under 7.3 than
7.2.3.  At first, I thought it would be a hardware issue, so i installed both
versions on the same box.  
7.2.3 tends to run the query in 80% of the time 7.3 does.
Explain output can be found at http://arch.wavefire.com/72v73a.txt

Please don't hesitate to drop me a line if you require more info.
 -Wade Klaver

Responses

pgsql-hackers by date

Next:From: Bruce MomjianDate: 2002-11-29 02:05:18
Subject: Re: nested transactions
Previous:From: Hannu KrosingDate: 2002-11-28 23:45:27
Subject: Re: Hirarchical queries a la Oracle. Patch.

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