Re: reloptions and toast tables - Mailing list pgsql-hackers

From Zdenek Kotala
Subject Re: reloptions and toast tables
Date
Msg-id 494E1105.5030809@sun.com
Whole thread Raw
In response to Re: reloptions and toast tables  (Alvaro Herrera <alvherre@commandprompt.com>)
Responses Re: reloptions and toast tables  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
Alvaro Herrera napsal(a):

> ALTER TABLE foo SET (toast.autovacuum_enabled = false);

+1

Do not forget on toast index as well.

ALTER TABLE foo SET (toast_idx.fillfactor = 50);

Another potential problem with toast setting is that reloption is toastable and 
it could generates loops in detoasting pg_class tuples. For example toast chunk 
size cannot be implement like reloption (or pg_class should use every time 
default values).
    Zdenek


pgsql-hackers by date:

Previous
From: Andrew Gierth
Date:
Subject: Re: a small proposal for avoiding foot-shooting
Next
From: KaiGai Kohei
Date:
Subject: Re: Updates of SE-PostgreSQL 8.4devel patches (r1324)