Re: slow query performance - Mailing list pgsql-performance

From Robert Haas
Subject Re: slow query performance
Date
Msg-id AANLkTilRWJ2ecRDCJkbXPZ3EhsEv2Vhr2oKTS72iTJPd@mail.gmail.com
Whole thread Raw
In response to Re: slow query performance  (Anj Adu <fotographs@gmail.com>)
Responses Re: slow query performance
List pgsql-performance
On Thu, Jun 10, 2010 at 11:32 AM, Anj Adu <fotographs@gmail.com> wrote:
> Attached

Hmm.  Well, I'm not quite sure what's going on here, but I think you
must be using a modified verison of PostgreSQL, because, as Tom
pointed out upthread, we don't have a data type called "timestamp with
time area".  It would be called "timestamp with time zone".

Can we see the index and table definitions of the relevant tables
(attached as a text file) and the size of each one (use select
pg_relation_size('name'))?

--
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise Postgres Company

pgsql-performance by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: Large (almost 50%!) performance drop after upgrading to 8.4.4?
Next
From: Robert Haas
Date:
Subject: Re: Performance tuning for postgres