Re: Anyone working on the TOAST items on the TODO list?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Bill Moran <wmoran(at)potentialtech(dot)com>
Cc: Josh Berkus <josh(at)agliodbs(dot)com>, pgsql-hackers(at)postgresql(dot)org
Subject: Re: Anyone working on the TOAST items on the TODO list?
Date: 2015-07-25 20:06:28
Message-ID: 23414.1437854788@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Bill Moran <wmoran(at)potentialtech(dot)com> writes:
> On Sat, 25 Jul 2015 11:39:15 -0700
> Josh Berkus <josh(at)agliodbs(dot)com> wrote:
>> Nope. In fact, even the one which was 90% complete (replacing zlib with
>> lz4) completely dropped off the radar.

> Interesting ... I wasn't looking at doing that, rather adjusting the
> decision logic on when to compress, as well as making the trigger values
> configurable so as to open the TOAST logic up to easy user configuration
> at the DB as well as the table level. I figure this will also need enough
> testing to feel like we're shipping with reasonable default values.

I have a vague feeling that we've accreted some code that has dependencies
on the current TOAST behavior. Unfortunately it's no more than a vague
feeling so I can't tell you where to look; but it'd be a good idea to look
around and/or test, rather than just assume we can let users frob these
knobs to whatever random settings they feel like.

I don't want to discourage you from the idea of making these things
accessible, just suggesting that there may be more work to do than simply
making them accessible. There may be a need for fairly strict sanity
checking on the values.

regards, tom lane

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Fabien COELHO 2015-07-25 20:14:09 Re: extend pgbench expressions with functions
Previous Message Bill Moran 2015-07-25 19:41:10 Re: Anyone working on the TOAST items on the TODO list?