Re: fillfactor using WITH syntax

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: ITAGAKI Takahiro <itagaki(dot)takahiro(at)oss(dot)ntt(dot)co(dot)jp>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: fillfactor using WITH syntax
Date: 2006-06-06 03:08:37
Message-ID: 9798.1149563317@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers pgsql-patches

ITAGAKI Takahiro <itagaki(dot)takahiro(at)oss(dot)ntt(dot)co(dot)jp> writes:
> Now, I want to ask you how to modify WITH parameters for existing
> tables/indexes.

I'd go with the ALTER TABLE, rather than cluttering N other commands.
There's already precedent for delayed effects of parameter alterations
(SET, ALTER SET STATISTICS, ALTER SET STORAGE, etc). Documenting which
commands cause the new values to take effect seems sufficient.

regards, tom lane

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Victor B. Wagner 2006-06-06 07:51:35 Contrib module to examine client certificate
Previous Message Tom Lane 2006-06-06 03:02:33 That EXPLAIN ANALYZE patch still needs work

Browse pgsql-patches by date

  From Date Subject
Next Message Tom Lane 2006-06-06 03:21:55 Re: remove lock protection on HeapTupleSatisfiesVacuum
Previous Message ITAGAKI Takahiro 2006-06-06 02:45:14 fillfactor using WITH syntax