Re: autovacuum and reloptions - Mailing list pgsql-hackers

From Alvaro Herrera
Subject Re: autovacuum and reloptions
Date
Msg-id 20090112111533.GA4919@alvh.no-ip.org
Whole thread Raw
In response to Re: autovacuum and reloptions  ("Robert Haas" <robertmhaas@gmail.com>)
Responses Re: autovacuum and reloptions  (Alvaro Herrera <alvherre@commandprompt.com>)
List pgsql-hackers
Robert Haas escribió:
> On Sun, Jan 11, 2009 at 6:47 PM, Euler Taveira de Oliveira
> <euler@timbira.com> wrote:
> > Robert Haas escreveu:
> >> Several things related to this patch have been committed:
> >>
> >> http://archives.postgresql.org/message-id/20081219143958.6F2DD7563FE@cvs.postgresql.org
> >> http://archives.postgresql.org/message-id/20090105171428.77B29754A17@cvs.postgresql.org
> >> (and several follow-on commits)
> >>
> >> What still remains to be done for 8.4?
> >>
> > autovacuum part?
> 
> I guess Alvaro is working on that?  Or are you?

I have a followup patch that allows one to use a namespace in ALTER
TABLE SET commands, like this:

alter table foo set (toast.fillfactor = 50)

This is still WIP because it has some minor annoyances.  I will finish
and commit the table-based amoptions infrastructure and then be back on
the namespace patch.

This namespace patch is a prerequisite of the autovacuum work, because
without it, it is impossible to change autovacuum settings for toast
tables, which would be a regression.

I have a separate branch on which I keep the old patch from Euler
updated to the current reloptions code; so it is probably very similar
to what Euler just sent.  (I'll have a look at that soon anyway.)

-- 
Alvaro Herrera                                http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support


pgsql-hackers by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: foreign_data test fails with non-C locale
Next
From: Devrim GÜNDÜZ
Date:
Subject: Re: foreign_data test fails with non-C locale