I tried to capture a screen shot and I changed language to en_US, then pgAdmin displayed proper values. When I changed it back to pl_PL (or default) I saw 0 again. So I think it could be related somehow with localization.
TOAST autovacuum has been enabled previously, so my script enables only autovacuum.
PostgreSQL 9.1.2, compiled by Visual C++ build 1500, 64-bit on Windows Serwer 2008 R2 Standard.
Regards,
Bartek
--- Oryginalna wiadomość ---
Od: Guillaume Lelarge [mailto: guillaume@lelarge.info] Wysłane: Wednesday, February 1, 2012 09:58 AM Do: bdmytrak@eranet.pl Kopia: pgadmin-support@postgresql.org Temat: Re: [pgadmin-support] Custom Auto Vacuum factors On Wed, 2012-02-01 at 09:02 +0100, bdmytrak@eranet.pl wrote: > 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.
I don't have the issue. It displays the right value. Widgets are disabled because I didn't set autovacuum_enabled. What I find weird is that you have autovacuum_enabled and toast.autovacuum_enabled set to true with only the SQL script you showed. I don't have that. I only have it if I execute also :
ALTER TABLE "public"."tblTest" SET ( autovacuum_enabled = true, autovacuum_vacuum_scale_factor = 0.002, autovacuum_analyze_scale_factor = 0.001, toast.autovacuum_enabled = true );
What version of PostgreSQL do you use? on which OS?
-- Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgadmin-support
