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

Re: Query performance

From: Christopher Kings-Lynne <chris(dot)kings-lynne(at)calorieking(dot)com>
To: Antonio Batovanja <antonio(dot)batovanja(at)humanomed(dot)co(dot)at>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Query performance
Date: 2006-05-31 01:07:34
Message-ID: 447CEC56.3070106@calorieking.com (view raw or flat)
Thread:
Lists: pgsql-performance
> I'm executing the queries from phpPgAdmin. 
> The above are for explain analyse. I was referring to the pure query
> execution time.
> Does anyone have an idea why the OR-query takes so long?
> Any server-side tuning possibilities? I wouldn't like to change the code of
> ldap's back-sql...

If you're using phpPgAdmin's timings, they could be more off than the 
real explain analyze timings.  Make sure you're using the figure given 
by explain analyze itself.

Chris


In response to

pgsql-performance by date

Next:From: Jim C. NasbyDate: 2006-05-31 01:09:22
Subject: Re: Bulk loading/merging
Previous:From: Jim C. NasbyDate: 2006-05-31 00:38:17
Subject: Re: Why the 8.1 plan is worst than 7.4?

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