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 20210527022412.kqujhfeblutq6cfm@alap3.anarazel.de
обсуждение исходный текст
Ответ на Re: Move pg_attribute.attcompression to earlier in struct for reduced size?  (Michael Paquier <michael@paquier.xyz>)
Список pgsql-hackers
Hi,

On 2021-05-27 11:07:53 +0900, Michael Paquier wrote:
> This depends on the number of attributes, but I do see an extra 0.5%
> __memmove_avx_unaligned_erms in reform_and_rewrite_tuple() for a
> normal VACUUM FULL with a 1-int-column relation on a perf profile,
> with rewrite_heap_tuple eating most of it as in the past, so that's
> within the noise bandwidth if you measure the runtime.
> What would be the worst case here, a table with one text column made
> of non-NULL still very short values?

I think you need a bunch of columns to see it, like in the benchmark I
just posted - I didn't test any other number of columns than 10 though.

Greetings,

Andres Freund



В списке pgsql-hackers по дате отправления:

Предыдущее
От: "tsunakawa.takay@fujitsu.com"
Дата:
Сообщение: RE: Parallel Inserts in CREATE TABLE AS
Следующее
От: Justin Pryzby
Дата:
Сообщение: Re: Speed up pg_checksums in cases where checksum already set