2012/3/20 Guillaume Lelarge <guilla...@lelarge.info> > 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 > > > -- > Guillaume > http://blog.guillaume.lelarge.info > http://www.dalibo.com > > Regards, Bartek