Re: Re: [COMMITTERS] pgsql: Update autovacuum to use reloptions instead of a system catalog,

From: Robert Haas <robertmhaas(at)gmail(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Alvaro Herrera <alvherre(at)commandprompt(dot)com>, ITAGAKI Takahiro <itagaki(dot)takahiro(at)oss(dot)ntt(dot)co(dot)jp>, pgsql-hackers(at)postgresql(dot)org
Subject: Re: Re: [COMMITTERS] pgsql: Update autovacuum to use reloptions instead of a system catalog,
Date: 2009-02-11 21:51:13
Message-ID: 603c8f070902111351s34c5dc8y764a3d9b88165dab@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-committers pgsql-hackers

On Wed, Feb 11, 2009 at 4:42 PM, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
> Robert Haas <robertmhaas(at)gmail(dot)com> writes:
>> FWIW, I don't really buy this argument. I can't see that it's all
>> that implausible to think that the user might be able to prognosticate
>> a reasonable value for a future TOAST table.
>
> Well, it still seems to me that such a user is really more interested in
> a way to set the default toast fillfactor (or whatever option is under
> discussion), ie what he really knows is a reasonable value for *all*
> future TOAST tables in his installation.

Maybe, or maybe he knows that this group of tables is typically pretty
stable, but this group over here has more frequent updates, so
different fillfactors are appropriate... doesn't have to be 100%
site-wide.

> Otherwise you're arguing that he knows exactly what the fillfactor
> should be for a specific toast table and not any other one ... except
> he doesn't know when that toast table is going to be created, which
> calls into question the quality of his judgment about its specific
> behavior otherwise.

Sure, but I think you're putting too much emphasis on the likely
quality of the user's judgment. It's not really the place of the
database to ignore user requests, even if they're likely stupid
requests.

WARNING: Type varchar(9) is likely inadequate for assumed purpose of
column `telephone_number'.

...Robert

In response to

Browse pgsql-committers by date

  From Date Subject
Next Message User Bmomjian 2009-02-11 22:40:25 pg-migrator - src: Add support for old/new superuser specification.
Previous Message Tom Lane 2009-02-11 21:42:34 Re: Re: [COMMITTERS] pgsql: Update autovacuum to use reloptions instead of a system catalog,

Browse pgsql-hackers by date

  From Date Subject
Next Message David Rowley 2009-02-11 22:21:06 Re: Bug #4284
Previous Message Tom Lane 2009-02-11 21:42:34 Re: Re: [COMMITTERS] pgsql: Update autovacuum to use reloptions instead of a system catalog,