Re: pgbench --tuple-size option

Поиск
Список
Период
Сортировка
От Fabien COELHO
Тема Re: pgbench --tuple-size option
Дата
Msg-id alpine.DEB.2.10.1408152255110.29316@sto
обсуждение исходный текст
Ответ на Re: pgbench --tuple-size option  (Andres Freund <andres@2ndquadrant.com>)
Список pgsql-hackers
>>> The custom initialization is to run a manual ALTER after the
>>> initialization.
>>
>> Sure, it can be done this way.
>>
>> I'm not sure about the implication of ALTER on the table storage,
>
> Should be fine in this case.

After some testing and laughing, my conclusion is "not fine at all". The 
"filler" attributes in "pgbench" are by default "EXTENDED", which mean 
possibly compressed... As the the default value is '', the compression, 
when tried for large sizes, performs very well, and the performance is the 
same as with a (declared) smaller tuple:-) Probably not the intention of 
the benchmark designer. Conclusion: I need an ALTER TABLE anyway to change 
the STORAGE. Or maybe pgbench should always do it anyway...

Conclusion 2: I've noted the submission as "rejected" as both you and 
Fujii don't like it, and although I found it useful, but I can do without 
it quite easily.

-- 
Fabien.



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

Предыдущее
От: Rahila Syed
Дата:
Сообщение: Re: [REVIEW] Re: Compression of full-page-writes
Следующее
От: Amit Kapila
Дата:
Сообщение: Re: option -T in pg_basebackup doesn't work on windows