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. >
Fixed by removing these options. > BTW. When Custom autovacuum is enabled and there are no custom values set, > then -1 is displayed - fields where empty in previous versions > Which is better, no? -- Guillaume http://blog.guillaume.lelarge.info http://www.dalibo.com -- Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgadmin-support
