Re: [pgadmin-hackers] Using Index to do sorting while using windowing function

2013-10-23 Thread Sameer Kumar
Hi, By mistake posted this in a wrong user group. Best Regards, *Sameer Kumar* On Wed, Oct 23, 2013 at 10:40 PM, Sameer Kumar wrote: > Hi, > > I was dealing with windowing function recently. I feel they are pretty > useful and quite handy in lot of operations. > > I am not sure why but my Post

[pgadmin-hackers] Using Index to do sorting while using windowing function

2013-10-23 Thread Sameer Kumar
Hi, I was dealing with windowing function recently. I feel they are pretty useful and quite handy in lot of operations. I am not sure why but my PostgreSQL does not seem to be using indexes for ORDER BY clause or PARTITION BY CLAUSE which I use with windowing function. I have tried ORDER BY and G