Re: Regarding Timezone - Mailing list pgsql-performance

From Tom Lane
Subject Re: Regarding Timezone
Date
Msg-id 504.1182270010@sss.pgh.pa.us
Whole thread Raw
In response to Regarding Timezone  ("soni de" <soni.de@gmail.com>)
List pgsql-performance
"soni de" <soni.de@gmail.com> writes:
> But we want to set this timezone parameter to IST.

Which "IST" are you interested in?  Irish, Israel, or Indian Standard Time?
Postgres prefers to use the zic timezone names, which are less
ambiguous.  Try this to see likely options:

regression=# select * from pg_timezone_names where abbrev = 'IST';
     name      | abbrev | utc_offset | is_dst
---------------+--------+------------+--------
 Asia/Calcutta | IST    | 05:30:00   | f
 Asia/Colombo  | IST    | 05:30:00   | f
 Europe/Dublin | IST    | 01:00:00   | t
 Eire          | IST    | 01:00:00   | t
(4 rows)

If you're after Indian Standard Time, set timezone to 'Asia/Calcutta'.
You'll probably also want to set timezone_abbreviations to 'India' so
that "IST" is interpreted the way you want in timestamp datatype input.
See
http://www.postgresql.org/docs/8.2/static/datetime-config-files.html

            regards, tom lane

pgsql-performance by date:

Previous
From: Gregory Stark
Date:
Subject: Re: Performance query about large tables, lots of concurrent access
Next
From: "Campbell, Lance"
Date:
Subject: PostgreSQL Configuration Tool for Dummies