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
);
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