Re: Query performance - Mailing list pgsql-performance

From Christopher Kings-Lynne
Subject Re: Query performance
Date
Msg-id 447CEC56.3070106@calorieking.com
Whole thread Raw
In response to Re: Query performance  (Antonio Batovanja <antonio.batovanja@humanomed.co.at>)
List 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


pgsql-performance by date:

Previous
From: "Jim C. Nasby"
Date:
Subject: Re: Bulk loading/merging
Next
From: Tom Lane
Date:
Subject: Re: Why the 8.1 plan is worst than 7.4?