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

From: Bill Moran <wmoran(at)potentialtech(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
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:25:46
Message-ID: 20150725162546.405eb4ef52e88a22dd8e29a9@potentialtech.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Sat, 25 Jul 2015 16:06:28 -0400
Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:

> 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.

Good to know. I guess it's a good thing that I'm giving myself a full year to
work on this ...

--
Bill Moran

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Andrew Dunstan 2015-07-25 20:38:54 Re: pg_dump -Fd and compression level
Previous Message Fabien COELHO 2015-07-25 20:14:09 Re: extend pgbench expressions with functions