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. BTW. When Custom autovacuum is enabled and there are no custom values set, then -1 is displayed - fields where empty in previous versions Environment: pgAdmin III 1.14.2 Win 7 32 bit PG 9.1.3 MS Server 2008 R2 64 bit Regards, Bartek
