Re: [PERFORM] Query Performance with Indexes on Integer type vs. Date type.

2011-04-27 Thread Dhimant Patel
of times of postgres documentation before I will have better grasp of all available tools but this forum is very valuable. -DP. On Wed, Apr 27, 2011 at 12:46 PM, Phoenix Kiula wrote: > On Thu, Apr 28, 2011 at 12:17 AM, Kevin Grittner > wrote: > > > > Dhimant Patel wrote: &g

[PERFORM] Query Performance with Indexes on Integer type vs. Date type.

2011-04-27 Thread Dhimant Patel
Hi All, I am a new comer on postgres world and now using it for some serious (at least for me) projects. I have a need where I am running some analytical + aggregate functions on data where ordering is done on Date type column. >From my initial read on documentation I believe internally a date t