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. -- 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: http://www.postgresql.org/mailpref/pgsql-hackers