Re: [GENERAL] PostgreSQL index issue

2012-07-12 Thread Albe Laurenz
mperformer 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

Re: [GENERAL] PostgreSQL index issue

2012-07-12 Thread codevally
Hi Laurenz Many thanks for your reply. Could you please bit more explain about the following sentence you wrote: There are no performance problems except the ones that always come with an index: INSERTs, UPDATEs and DELETEs will be slower and do more disk I/O and locking. Many Thanks -- View

Re: [GENERAL] PostgreSQL index issue

2012-07-12 Thread Craig Ringer
On 07/13/2012 06:06 AM, codevally wrote: Hi Laurenz Many thanks for your reply. Could you please bit more explain about the following sentence you wrote: There are no performance problems except the ones that always come with an index: INSERTs, UPDATEs and DELETEs will be slower and do more

[GENERAL] PostgreSQL index issue

2012-07-11 Thread mperformer
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