Hi,
I executed SQL like this one:
ALTER TABLE "public"."tblTest" SET (
autovacuum_vacuum_scale_factor = 0.002,
autovacuum_analyze_scale_factor = 0.001
);
to set custom autovacuum parameters. pgAdmin in table property tab shows 0 for vacuum and analyze scale factors instead of 0.002 and 0.001. Script for table is generated properly:
...
WITH (
OIDS=FALSE,
autovacuum_enabled=true,
autovacuum_vacuum_scale_factor=0.002,
autovacuum_analyze_scale_factor=0.001,
toast.autovacuum_enabled=true
);
pgAdmin III 1.14.1 on Windows 7.
Regards,
Bartek