Re: Querying 19million records very slowly

From: Stefan Weiss <spaceman(at)foo(dot)at>
To: pgsql-performance(at)postgresql(dot)org
Subject: Re: Querying 19million records very slowly
Date: 2005-06-22 15:23:41
Message-ID: 42B9827D.40609@foo.at
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Tobias Brox 2005-06-22 16:28:44 Re: Querying 19million records very slowly
Previous Message Frank Wiles 2005-06-22 14:52:27 Performance Tuning Article