reloptions and toast tables

From: Alvaro Herrera <alvherre(at)commandprompt(dot)com>
To: Pg Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: reloptions and toast tables
Date: 2008-12-20 23:01:40
Message-ID: 20081220230140.GB3989@alvh.no-ip.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Right now we don't allow setting reloptions to toast tables:

=# alter table pg_toast.pg_toast_16395 set (fillfactor = 40);
ERROR: "pg_toast_16395" is not a table or index

However this is needed for autovacuum, per previous discussion.

I'm wondering if I should just allow all reloptions (including
fillfactor) or just the autovacuum ones.

--
Alvaro Herrera http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Andrew Dunstan 2008-12-20 23:07:00 Re: [COMMITTERS] pgsql: Append major version number and for libraries soname major
Previous Message Alvaro Herrera 2008-12-20 22:59:27 Re: [COMMITTERS] pgsql: Append major version number and for libraries soname major