PostgreSQL index issue

From: mperformer <codevally(dot)mail(dot)list(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: PostgreSQL index issue
Date: 2012-07-12 02:06:10
Message-ID: CAOokBJGA56tiyLZGPf859fmLiZidpp19Q5pPbT65Hwc4wORegg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi Fellows

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.

Roshan

Responses

Browse pgsql-general by date

  From Date Subject
Next Message KOTa 2012-07-12 03:05:49 Re: installation problem with postgres password
Previous Message Craig Ringer 2012-07-12 02:05:15 Re: Error with plpython