Postgres Pro
Downloads
Home   >   mailing lists

Using indexes for ORDER BY and PARTITION BY clause in windowing functions - Mailing list pgsql-hackers

From Sameer Kumar
Subject Using indexes for ORDER BY and PARTITION BY clause in windowing functions
Date
Msg-id CADp-Sm7fsjFU0ijcbYME0QLgu7BhWK4oafoSr=5FRqz1mGx+kA@mail.gmail.com
Whole thread Raw
Responses Re: Using indexes for ORDER BY and PARTITION BY clause in windowing functions  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
Tree view
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 GROUP BY clauses in a normal sql statement and they seem to use indexes nicely.

Is this being already considered for development?

Best Regards,
Sameer Kumar | Database Consultant
ASHNIK PTE. LTD.


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: Why the asprintf patch is still breaking the buildfarm
Next
From: Robert Haas
Date:
Subject: Re: Sigh, my old HPUX box is totally broken by DSM patch