Received: from makus.postgresql.org (makus.postgresql.org [98.129.198.125])
	by mail.postgresql.org (Postfix) with ESMTP id D2FC81F6FE32
	for <pgsql-performance@postgresql.org>;
	Wed, 11 Jul 2012 21:03:53 -0300 (ADT)
Received: from sam.nabble.com ([216.139.236.26])
	by makus.postgresql.org with esmtp (Exim 4.72)
	(envelope-from <codevally.mail.list@gmail.com>) id 1Sp6sq-0007go-H6
	for pgsql-performance@postgresql.org; Thu, 12 Jul 2012 00:03:52 +0000
Received: from [192.168.236.26] (helo=sam.nabble.com)
	by sam.nabble.com with esmtp (Exim 4.72)
	(envelope-from <codevally.mail.list@gmail.com>) id 1Sp6sd-0000RU-5U
	for pgsql-performance@postgresql.org; Wed, 11 Jul 2012 17:03:39 -0700
Date: Wed, 11 Jul 2012 17:03:39 -0700 (PDT)
From: codevally <codevally.mail.list@gmail.com>
To: pgsql-performance@postgresql.org
Message-ID: <1342051419163-5716322.post@n5.nabble.com>
Subject: PostgreSQL index issue
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
X-Pg-Spam-Score: 0.0 (/)
X-Archive-Number: 201207/168
X-Sequence-Number: 47349

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





--
View this message in context: http://postgresql.1045698.n5.nabble.com/PostgreSQL-index-issue-tp5716322.html
Sent from the PostgreSQL - performance mailing list archive at Nabble.com.