Re: Weird performance hit

From: Michael Fuhr <mike(at)fuhr(dot)org>
To: WireSpot <wirespot(at)gmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Weird performance hit
Date: 2005-08-18 12:26:41
Message-ID: 20050818122641.GA83562@winnie.fuhr.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Michael Fuhr 2005-08-18 12:30:07 Re: Weird performance hit
Previous Message Ronzani Dario 2005-08-18 12:15:36 R: Linux Postgres authentication against active directory