On Fri, Oct 14, 2016 at 9:51 AM, Tom Lane <t...@sss.pgh.pa.us> wrote:
> Robert Haas <robertmh...@gmail.com> writes:
>> Today, I tried compiling with:
>> +#define TOAST_TUPLE_THRESHOLD   100
>> Most of the regression tests pass just fine, but the tablesample one
>> experiences numerous failures.  For example:
>> ...
>> Most of the failures are due to table-sampling that previously
>> returned rows no longer returning any rows.  I don't know why that
>> should happen, or whether it's expected.
> I think it's probably unsurprising.  That test doesn't load very many
> rows, and when you allow them to become toasted, they probably all fit
> into one page.  The SYSTEM tablesample method would then return either
> every row, or no row.
> 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.

Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company

Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:

Reply via email to