| From: | "Albe Laurenz" <laurenz(dot)albe(at)wien(dot)gv(dot)at> |
|---|---|
| To: | "codevally *EXTERN*" <codevally(dot)mail(dot)list(at)gmail(dot)com>, <pgsql-performance(at)postgresql(dot)org> |
| Subject: | Re: PostgreSQL index issue |
| Date: | 2012-07-16 07:44:31 |
| Message-ID: | D960CB61B694CF459DCFB4B0128514C208246B4D@exadv11.host.magwien.gv.at |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
codevally wrote:
> I have a question regarding PostgreSQL 9.1 indexing.
>
> I am having a table and want to create a index for a column and I want
to
> store the data with time zone for that column. The questions are:
>
> 1. Can I create a index for a column which store time stamp with time
zone.
> If can is there ant performance issues?
>
> 2. Also I can store the time stamp value with zone as a long integer
value.
> If so what is the difference between the above step. Which one is
better.
>
> Many Thanks.
If you didn't like the answer that you got to exactly the same
question on
http://archives.postgresql.org/message-id/CAOokBJGA56tiyLZGPf859fmLiZidp
p19Q5pPbT65Hwc4wORegg%40mail.gmail.com
why didn't you say so?
Yours,
Laurenz Albe
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Ioannis Anagnostopoulos | 2012-07-16 10:24:27 | Re: Index slow down insertions... |
| Previous Message | Craig Ringer | 2012-07-16 01:54:44 | Proposed change for 9.3(?): Require full restart to change fsync parameter, not just pg_ctl reload |