Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
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: Wed, 31 May 2006 09:07:34 +0800
I'm executing the queries from phpPgAdmin. The above are for explain analyse. I was referring to the pure queryexecution 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
- References:
- Re: Query performance
- From: Steinar H. Gunderson
- Re: Query performance
- From: Antonio Batovanja
- Re: Query performance
- Prev by Date: Re: Bulk loading/merging
- Next by Date: Re: Why the 8.1 plan is worst than 7.4?
- Previous by thread: Re: Query performance
- Next by thread: Re: Query performance
- Indexes: