Postgres Pro
Downloads
Home   >   mailing lists

Re: Weird performance hit - Mailing list pgsql-general

From Michael Fuhr
Subject Re: Weird performance hit
Date
Msg-id 20050818122641.GA83562@winnie.fuhr.org
Whole thread Raw
In response to Weird performance hit  (WireSpot <wirespot@gmail.com>)
Responses Re: Weird performance hit  (Michael Fuhr <mike@fuhr.org>)
List pgsql-general
Tree view 
On Thu, Aug 18, 2005 at 10:03:38AM +0300, WireSpot wrote:
> However, one application is for some weird reason taking a serious
> performance hit on certain pages. There are some intensive joins and
> selects there, but somehow one install manages a couple of seconds and
> the other takes about 10.

Could you post the query and the EXPLAIN ANALYZE output for both
systems?

--
Michael Fuhr

pgsql-general by date:

Previous
From: "Ronzani Dario"
Date:
Subject: R: Linux Postgres authentication against active directory
Next
From: Michael Fuhr
Date:
Subject: Re: Weird performance hit