Postgres Pro
Downloads
Home   >   mailing lists

Re: cutting down the TODO list thread - Mailing list pgsql-hackers

From John Naylor
Subject Re: cutting down the TODO list thread
Date
Msg-id CAFBsxsEm142-PEC8yb5v5BXgXVJs-K12Go-FchmZ=2+sM-7yNA@mail.gmail.com
Whole thread Raw
In response to Re: cutting down the TODO list thread  (Bruce Momjian <bruce@momjian.us>)
Responses Re: cutting down the TODO list thread
List pgsql-hackers
Tree view
Here I'm just reviewing a couple items in the Sorting section:


- Consider whether duplicate keys should be sorted by block/offset

https://www.postgresql.org/message-id/flat/23321.1205726381%40sss.pgh.pa.us

It's moot since we started requiring tid as a tiebreaker for btree indexes, so I'll just remove this.

- Consider being smarter about memory and external files used during sorts

https://www.postgresql.org/message-id/1196186626.4246.1078.camel@ebony.site

We've had a large number of improvements in this area since 2007, and it seems the ideas in this thread have mostly been done or superseded already. 

--

pgsql-hackers by date:

Previous
From: Peter Geoghegan
Date:
Subject: Re: pg14b2: FailedAssertion("_bt_posting_valid(nposting)", File: "nbtdedup.c", ...
Next
From: Jeff Davis
Date:
Subject: Re: Synchronous commit behavior during network outage