Re: Move pg_attribute.attcompression to earlier in struct for reduced size?
От | Andres Freund |
---|---|
Тема | Re: Move pg_attribute.attcompression to earlier in struct for reduced size? |
Дата | |
Msg-id | 20210527015415.ctuj4yrwnjip5kve@alap3.anarazel.de обсуждение исходный текст |
Ответ на | Re: Move pg_attribute.attcompression to earlier in struct for reduced size? (Tom Lane <tgl@sss.pgh.pa.us>) |
Ответы |
Re: Move pg_attribute.attcompression to earlier in struct for reduced size?
Re: Move pg_attribute.attcompression to earlier in struct for reduced size? |
Список | pgsql-hackers |
Hi, On 2021-05-26 20:35:46 -0400, Tom Lane wrote: > Andres Freund <andres@anarazel.de> writes: > > The efficiency bit is probably going to be swamped by the addition of > > the compression handling, given the amount of additional work we're now > > doing in in reform_and_rewrite_tuple(). > > Only if the user has explicitly requested a change of compression, no? Oh, it'll definitely be more expensive in that case - but that seems fair game. What I was wondering about was whether VACUUM FULL would be measurably slower, because we'll now call toast_get_compression_id() on each varlena datum. It's pretty easy for VACUUM FULL to be CPU bound already, and presumably this'll add a bit. Greetings, Andres Freund
В списке pgsql-hackers по дате отправления: