Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-performance by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group