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 MaximumBytesPerTuple(TOAST_TUPLES_PER_PAGE)
>> +#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.
The Enterprise PostgreSQL Company
Sent via pgsql-hackers mailing list (email@example.com)
To make changes to your subscription: