Postgres Pro
Downloads
Home   >   mailing lists

RE: New Window Function: ROW_NUMBER_DESC() OVER() ? - Mailing list pgsql-hackers

From Maiquel Grassi
Subject RE: New Window Function: ROW_NUMBER_DESC() OVER() ?
Date
Msg-id CP8P284MB249618F6221859BBC4B9E77BEC732@CP8P284MB2496.BRAP284.PROD.OUTLOOK.COM
Whole thread Raw
In response to Re: New Window Function: ROW_NUMBER_DESC() OVER() ?  ("David G. Johnston" <david.g.johnston@gmail.com>)
Responses New Window Function: ROW_NUMBER_DESC() OVER() ?
List pgsql-hackers
Tree view
Hi,

Count() over() - row_number() over()
  
   But if my dataset is significantly large? Wouldn't calling two window functions instead of one be much slower?
   Is count() over() - row_number() over() faster than row_number_desc() over()?

Maiquel.

pgsql-hackers by date:

Previous
From: Robert Haas
Date:
Subject: Re: index prefetching
Next
From: "David G. Johnston"
Date:
Subject: New Window Function: ROW_NUMBER_DESC() OVER() ?