On Tue, 2012-03-20 at 09:02 +0100, Bartosz Dmytrak wrote:
> Hi,
> it is possible to set autovacuum_analyze_threshold
> and autovacuum_analyze_scale_factor for TOAST tables using pgAdmin.
> Script generated is like this:
>
> ALTER TABLE "MySchema"."MyTable" SET (
> toast.autovacuum_analyze_threshold = 50,
> toast.autovacuum_analyze_scale_factor = 0.1
> );
>
> according to doc
>
http://www.postgresql.org/docs/9.1/static/sql-createtable.html#SQL-CREATETABLE-STORAGE-PARAMETERS > there
> is no corresponding autovacuum_analyze_threshold
> and autovacuum_analyze_scale_factor for toast tables, and PG generates
> error when OK button is pressed - what is expected.
>
> My suggestion is to disable/remove these options in Toast Table tab in
> Table Properties dialog.
>