Re: HOT update: why must ALL indexes should be update?

2023-04-28 Thread Bruce Momjian
On Fri, Apr 21, 2023 at 10:19:42AM -0400, Tom Lane wrote: > Daniel Wu writes: > > We have many indexes on a table. The chance is that any column could be > > some part of an index. I understand that when an index has a column that is > > updated, we can't use HOT, because the index entry could poi

Re: PostgreSQL in-transit compression for a client connection

2023-04-28 Thread Dominique Devienne
On Fri, Apr 28, 2023 at 9:03 AM Magnus Hagander wrote: > On Thu, Apr 27, 2023 at 11:55 AM Laurenz Albe > wrote: > > > > On Thu, 2023-04-27 at 11:44 +0200, Dominique Devienne wrote: > > > as someone who must store ZLIB (from ZIP files) > > > and sometimes LZ4 compressed `bytea` values, I often fi

Re: PostgreSQL in-transit compression for a client connection

2023-04-28 Thread Magnus Hagander
On Thu, Apr 27, 2023 at 11:55 AM Laurenz Albe wrote: > > On Thu, 2023-04-27 at 11:44 +0200, Dominique Devienne wrote: > > as someone who must store ZLIB (from ZIP files) > > and sometimes LZ4 compressed `bytea` values, I often find it's a shame that > > I have > > to decompress them, send them ov