Re: tablesample test failure with small TOAST_TUPLE_THRESHOLD

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: tablesample test failure with small TOAST_TUPLE_THRESHOLD
Дата
Msg-id 13200.1476468141@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: tablesample test failure with small TOAST_TUPLE_THRESHOLD  (Robert Haas <robertmhaas@gmail.com>)
Список pgsql-hackers
Robert Haas <robertmhaas@gmail.com> writes:
> On Fri, Oct 14, 2016 at 9:51 AM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
>> Possibly we should be using a less chintzy (ie slower) test there,
>> but a change like this would inevitably change the outputs anyway.

> OK.  So passing the regression tests with different values of
> TOAST_TUPLE_THRESHOLD is not a goal?  I wasn't sure about that, but if
> the answer is "no, that's not a goal", that's fine.

For that particular test, I really fail to see how we could make the
output entirely independent of the number of tuples stored per page.
By design, that tablesample method is sensitive to where the page
boundaries are.
        regards, tom lane



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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Re: [COMMITTERS] pgsql: Extend framework from commit 53be0b1ad to report latch waits.
Следующее
От: Robert Haas
Дата:
Сообщение: Re: Re: [COMMITTERS] pgsql: Extend framework from commit 53be0b1ad to report latch waits.