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.
--- Oryginalna wiadomo?? ---
Od: Guillaume Lelarge [mailto: guillaume(at)lelarge(dot)info]
Wys?ane: Wednesday, February 1, 2012 09:58 AM
Temat: Re: [pgadmin-support] Custom Auto Vacuum factors
On Wed, 2012-02-01 at 09:02 +0100, bdmytrak(at)eranet(dot)pl wrote:
> 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 (
> 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?
PostgreSQL Sessions #3: http://www.postgresql-sessions.org
Sent via pgadmin-support mailing list (pgadmin-support(at)postgresql(dot)org)
To make changes to your subscription:
pgadmin-support by date
|Next:||From: Colin Beckingham||Date: 2012-02-02 20:11:59|
|Subject: Pgadmin3 : Opensuse 11.4 to 12.1 upgrade|
|Previous:||From: Kieran McCusker||Date: 2012-02-01 10:51:32|
|Subject: Re: Performance of pgAdmin 14 Beta 2|