Re: Move pg_attribute.attcompression to earlier in struct for reduced size?
От | Tom Lane |
---|---|
Тема | Re: Move pg_attribute.attcompression to earlier in struct for reduced size? |
Дата | |
Msg-id | 1885750.1622146678@sss.pgh.pa.us обсуждение исходный текст |
Ответ на | Re: Move pg_attribute.attcompression to earlier in struct for reduced size? (Alvaro Herrera <alvherre@alvh.no-ip.org>) |
Ответы |
Re: Move pg_attribute.attcompression to earlier in struct for reduced size?
|
Список | pgsql-hackers |
Alvaro Herrera <alvherre@alvh.no-ip.org> writes: > Now about the former. If we do think that recompressing causes an > unacceptable 10% slowdown for every single VACUUM FULLs, then yeah we > should discuss changing that behavior -- maybe remove promises of > recompression and wait for pg15 to add "VACUUM (RECOMPRESS)" or > similar. > If it's a 10% slowdown of the only best times (variability unspecified) > and only in corner cases (unlogged tables with no indexes that fit in > shared buffers), then I don't think we should bother. BTW, perhaps I should clarify my goal here: it's to cut off expending further effort on this feature during v14. If we can decide that the existing performance situation is acceptable, I'm content with that decision. But if we're to start designing new user-visible behavior to satisfy performance objections, then I'd prefer to remove this VACUUM behavior altogether for now. regards, tom lane
В списке pgsql-hackers по дате отправления: