Re: Querying 19million records very slowly - Mailing list pgsql-performance

From Stefan Weiss
Subject Re: Querying 19million records very slowly
Date
Msg-id 42B9827D.40609@foo.at
Whole thread Raw
In response to Re: Querying 19million records very slowly  (Michael Glaesemann <grzm@myrealbox.com>)
List pgsql-performance
On 2005-06-22 10:55, Michael Glaesemann wrote:
> There has been discussion in the past on storing the time zone name
> with the timestamptz as well, though no one has implemented this yet.

The reason for this may be that time zone names (abbreviations) are not
unique. For example, "ECT" can mean "Ecuador Time" (offset -05) or
"Eastern Caribbean Time" (offset -04).

http://www.worldtimezone.com/wtz-names/timezonenames.html

cheers,
stefan

pgsql-performance by date:

Previous
From: Frank Wiles
Date:
Subject: Performance Tuning Article
Next
From: "Kevin Grittner"
Date:
Subject: Re: Limit clause not using index