Postgres Pro
Downloads
Home   >   mailing lists

Re: Query Performance with Indexes on Integer type vs. Date type. - Mailing list pgsql-performance

From Tom Lane
Subject Re: Query Performance with Indexes on Integer type vs. Date type.
Date
Msg-id 17017.1303920717@sss.pgh.pa.us
Whole thread Raw
In response to Query Performance with Indexes on Integer type vs. Date type.  (Dhimant Patel <drp4kri@gmail.com>)
List pgsql-performance
Tree view 
Dhimant Patel <drp4kri@gmail.com> writes:
> From my initial read on documentation I believe internally a date type is
> represented by integer type of data. This makes me wonder would it make any
> good to create additional  column of Integer type and update it as data gets
> added and use this integer column for all ordering purposes for my sqls - or
> should I not hasitate using Date type straight into my sql for ordering?

Don't overcomplicate things.  Comparison of dates is just about as fast as
comparison of integers, anyway.

            regards, tom lane

pgsql-performance by date:

Previous
From: Dhimant Patel
Date:
Subject: Query Performance with Indexes on Integer type vs. Date type.
Next
From: Maciek Sakrejda
Date:
Subject: Re: Query Performance with Indexes on Integer type vs. Date type.