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.
Thanks
> 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?
I used to null values, -1 is strange, but still acceptable