Re: pgsql: Add various assertions to heap pruning code.

2021-11-04 Thread Michael Paquier
Hi Peter, On Fri, Nov 05, 2021 at 02:09:47AM +, Peter Geoghegan wrote: > Add various assertions to heap pruning code. > > These assertions document (and verify) our high level assumptions about > how pruning can and cannot affect existing items from target heap pages. > For example, one of th

pgsql: Improve psql tab completion for COMMENT

2021-11-04 Thread Michael Paquier
Improve psql tab completion for COMMENT Completion is added for more object types, like domain constraints, text search-ish objects or policies. Moreover, the area is reorganized, changing the list of objects supported by COMMENT to be in the same order as the documentation to ease future additio

pgsql: Add hardening to catch invalid TIDs in indexes.

2021-11-04 Thread Peter Geoghegan
Add hardening to catch invalid TIDs in indexes. Add hardening to the heapam index tuple deletion path to catch TIDs in index pages that point to a heap item that index tuples should never point to. The corruption we're trying to catch here is particularly tricky to detect, since it typically invo

pgsql: Add support for LZ4 compression in pg_receivewal

2021-11-04 Thread Michael Paquier
Add support for LZ4 compression in pg_receivewal pg_receivewal gains a new option, --compression-method=lz4, available when the code is compiled with --with-lz4. Similarly to gzip, this gives the possibility to compress archived WAL segments with LZ4. This option is not compatible with --compres

pgsql: Add various assertions to heap pruning code.

2021-11-04 Thread Peter Geoghegan
Add various assertions to heap pruning code. These assertions document (and verify) our high level assumptions about how pruning can and cannot affect existing items from target heap pages. For example, one of the new assertions verifies that pruning does not set a heap-only tuple to LP_DEAD. Aut

Re: pgsql: Fix snapshot reference leak if lo_export fails.

2021-11-04 Thread Andrew Dunstan
On 11/3/21 13:47, Heikki Linnakangas wrote: > On 03/11/2021 13:06, Daniel Gustafsson wrote: >>> On 3 Nov 2021, at 10:44, Heikki Linnakangas >>> wrote: >> >>> Fix snapshot reference leak if lo_export fails. >> >> This commit seems to lack the update in largeobject_1 as per hamerkop >> in: > > Fix