Postgres Pro
Downloads
Home   >   mailing lists

Re: Major performance problem after upgrade from 8.3 to 8.4 - Mailing list pgsql-performance

From Tom Lane
Subject Re: Major performance problem after upgrade from 8.3 to 8.4
Date
Msg-id 25560.1283534215@sss.pgh.pa.us
Whole thread Raw
In response to Re: Major performance problem after upgrade from 8.3 to 8.4  (Gerhard Wiesinger <lists@wiesinger.com>)
Responses Re: Major performance problem after upgrade from 8.3 to 8.4
List pgsql-performance
Tree view 
Gerhard Wiesinger <lists@wiesinger.com> writes:
> On Fri, 3 Sep 2010, Tom Lane wrote:
>> Huh.  Try strace'ing the process to see what it's doing.

> It tries to find something in /usr/share/ ...
> Ok, I think from the compile time options:
> ./configure --with-system-tzdata=/usr/share

Doh.  I hadn't looked closely at that.  Probably you want
/usr/share/zoneinfo --- at least that's what the Red Hat RPMs use.

            regards, tom lane

pgsql-performance by date:

Previous
From: Tom Lane
Date:
Subject: Re: Question about LEFT JOIN and query plan
Next
From: "Kevin Grittner"
Date:
Subject: Re: Question about LEFT JOIN and query plan