Re: autovacuum and reloptions

Robert Haas escribió:
> On Sun, Jan 11, 2009 at 6:47 PM, Euler Taveira de Oliveira
> <euler(at)timbira(dot)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