From: | Simon Riggs <simon(at)2ndquadrant(dot)com> |
---|---|
To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Cc: | Andres Freund <andres(at)anarazel(dot)de>, pgsql-committers <pgsql-committers(at)postgresql(dot)org> |
Subject: | Re: pgsql: Parameter toast_tuple_target controls TOAST for new rows |
Date: | 2017-11-20 07:09:56 |
Message-ID: | CANP8+jJoJEs_8khriDAGqR4SbizbrTbaACKu6wwnsovcmOJfXA@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-committers |
On 19 November 2017 at 20:30, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
> Andres Freund <andres(at)anarazel(dot)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.
Roughly that.
> Setting STORAGE = EXTERNAL on the data column to disable
> compression would help make things more stable, too.
That was already set at line 350
--
Simon Riggs http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services
From | Date | Subject | |
---|---|---|---|
Next Message | amul sul | 2017-11-20 12:46:51 | Re: [COMMITTERS] pgsql: Add hash partitioning. |
Previous Message | Simon Riggs | 2017-11-20 07:06:05 | Re: pgsql: Parameter toast_tuple_target controls TOAST for new rows |