Skip site navigation (1) Skip section navigation (2)

Re: performance issue with a specific query

From: "Merlin Moncure" <mmoncure(at)gmail(dot)com>
To: Eliott <eliott100(at)gmail(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: performance issue with a specific query
Date: 2006-07-27 14:52:31
Message-ID: b42b73150607270752x7137dbbeu419589b89f22c24d@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-performance
On 7/27/06, Eliott <eliott100(at)gmail(dot)com> wrote:
> Hi!
>
> I hope I'm sending my question to the right list, please don't flame if it's
> the wrong one.
>
> I have noticed that while a query runs in about 1.5seconds on a 8.xx version
> postgresql server on our 7.4.13 it takes around 15-20 minutes. Since we are
> using RHEL4 on our server we are stuck with 7.4.13. The enormous time
> difference between the different builds drives me crazy. Can you please help
> me identifying the bottleneck or suggest anything to improve the dismal
> performance.
> The query is the following:
>

try turning off genetic query optimization.  regarding the rhel4
issue...does rhel not come with a c compiler? :)

merlin

In response to

Responses

pgsql-performance by date

Next:From: Joshua D. DrakeDate: 2006-07-27 15:39:42
Subject: Re: performance issue with a specific query
Previous:From: Scott MarloweDate: 2006-07-27 14:46:26
Subject: Re: performance issue with a specific query

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group