Re: First draft of the PG 15 release notes (sorting)

2022-05-11 Thread Bruce Momjian
On Thu, May 12, 2022 at 01:59:36PM +1200, Thomas Munro wrote: > On Thu, May 12, 2022 at 12:53 PM Bruce Momjian wrote: > > > > > > Improve performance and reduce memory consumption of in-memory > > sorts (Ronan Dunklau, David Rowley, Thomas Munro) > > > >

Re: First draft of the PG 15 release notes (sorting)

2022-05-11 Thread Thomas Munro
On Thu, May 12, 2022 at 12:53 PM Bruce Momjian wrote: > > > Improve performance and reduce memory consumption of in-memory > sorts (Ronan Dunklau, David Rowley, Thomas Munro) > > I'd also add John Naylor here, as he did a lot of work to validate

Re: First draft of the PG 15 release notes (sorting)

2022-05-11 Thread Bruce Momjian
On Thu, May 12, 2022 at 10:38:42AM +1200, David Rowley wrote: > On Wed, 11 May 2022 at 14:38, Justin Pryzby wrote: > > I wonder if this is also relevant. > > > > 65014000b35 Replace polyphase merge algorithm with a simple balanced k-way > > merge. > > Thanks for highlighting that. It very much i

Re: First draft of the PG 15 release notes (sorting)

2022-05-11 Thread David Rowley
On Wed, 11 May 2022 at 14:38, Justin Pryzby wrote: > I wonder if this is also relevant. > > 65014000b35 Replace polyphase merge algorithm with a simple balanced k-way > merge. Thanks for highlighting that. It very much is relevant. In fact, it seems to account for most of the 25% I mentioned. T

Re: First draft of the PG 15 release notes (sorting)

2022-05-10 Thread David Rowley
On Wed, 11 May 2022 at 14:38, Justin Pryzby wrote: > > On Wed, May 11, 2022 at 12:39:41PM +1200, David Rowley wrote: > > I think the sort improvements done in v15 are worth a mention under > > General Performance. The commits for this were 91e9e89dc, 40af10b57 > > and 697492434. I've been runnin

Re: First draft of the PG 15 release notes (sorting)

2022-05-10 Thread Justin Pryzby
On Wed, May 11, 2022 at 12:39:41PM +1200, David Rowley wrote: > I think the sort improvements done in v15 are worth a mention under > General Performance. The commits for this were 91e9e89dc, 40af10b57 > and 697492434. I've been running a few benchmarks between v14 and v15 > over the past few day