Re: Why percent_rank is so slower than rank? - Mailing list pgsql-hackers

From Ron Mayer
Subject Re: Why percent_rank is so slower than rank?
Date
Msg-id 4D068A6D.9090402@cheapcomplexdevices.com
Whole thread Raw
In response to Re: Why percent_rank is so slower than rank?  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
Tom Lane wrote:
> argue that there was a regression.  It's certainly a performance bug
> though: nobody would expect that giving a query *more* work_mem would
> cause it to run many times slower.

I wouldn't be that surprised - otherwise it'd just be hard-coded to
something large.

Especially since earlier in the thread:
> The example is *not* particularly slow if you leave work_mem at default.
which makes me think it's arguably not quite a bug.




pgsql-hackers by date:

Previous
From: Pavel Stehule
Date:
Subject: Re: hstores in pl/python
Next
From: Dimitri Fontaine
Date:
Subject: Re: CommitFest wrap-up