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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse pgsql-performance by date

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