From: | Anj Adu <fotographs(at)gmail(dot)com> |
---|---|
To: | Robert Haas <robertmhaas(at)gmail(dot)com> |
Cc: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Andy Colson <andy(at)squeakycode(dot)net>, pgsql-performance(at)postgresql(dot)org |
Subject: | Re: slow query performance |
Date: | 2010-06-10 16:58:59 |
Message-ID: | AANLkTimGP9N8Pv6abhQharbHbcUiD6KaWom8BbSFBaZN@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-performance |
you are right..the word "zone" was replaced by "area" (my bad )
everything else is as is.
Apologies for the confusion.
On Thu, Jun 10, 2010 at 9:42 AM, Robert Haas <robertmhaas(at)gmail(dot)com> wrote:
> On Thu, Jun 10, 2010 at 11:32 AM, Anj Adu <fotographs(at)gmail(dot)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
>
From | Date | Subject | |
---|---|---|---|
Next Message | Magnus Hagander | 2010-06-10 17:30:00 | Re: Error with GIT Repository |
Previous Message | Robert Haas | 2010-06-10 16:44:27 | Re: Performance tuning for postgres |