Re: pgsql: Parameter toast_tuple_target controls TOAST for new rows

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: pgsql: Parameter toast_tuple_target controls TOAST for new rows
Дата
Msg-id 8972.1511141445@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: pgsql: Parameter toast_tuple_target controls TOAST for new rows  (Andres Freund <andres@anarazel.de>)
Ответы Re: pgsql: Parameter toast_tuple_target controls TOAST for new rows
Список pgsql-committers
Andres Freund <andres@anarazel.de> writes:
> On 2017-11-19 19:49:01 -0500, Tom Lane wrote:
>> TBH, I would just remove those test cases.  Even if they were stable
>> across platforms, they don't directly prove anything at all about
>> whether the feature does what it's supposed to.

> I think it might make sense to rewrite the tests so it doesn't output
> any of the sizes, but instead just compares the size of tables with
> different thresholds. That should be fairly reliable.

Hm, what I'd try after a bit of thought is to stuff the same data
into two different tables with different settings chosen to make it
TOAST or not, and then just test the toast tables for zero or nonzero
size.  Setting STORAGE = EXTERNAL on the data column to disable
compression would help make things more stable, too.
        regards, tom lane


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

Предыдущее
От: Simon Riggs
Дата:
Сообщение: Re: pgsql: Parameter toast_tuple_target controls TOAST for new rows
Следующее
От: Simon Riggs
Дата:
Сообщение: Re: pgsql: Parameter toast_tuple_target controls TOAST for new rows