Where's the query? Are you able to run explain analyze so we can see
estimates vs actual counts? What version are you using?
Can you share explain analyze before and after the window function?
I mean, that limit at the top makes me think it is doing a lot less work
without the window function, vs examining all candidate rows if we need to
count them all. What are you using that count for anyway? Pagination?
>