Skip site navigation (1) Skip section navigation (2)

Re: Custom Auto Vacuum factors

From: "bdmytrak(at)eranet(dot)pl" <bdmytrak(at)eranet(dot)pl>
To: guillaume(at)lelarge(dot)info
Cc: pgadmin-support(at)postgresql(dot)org
Subject: Re: Custom Auto Vacuum factors
Date: 2012-02-01 13:26:38
Message-ID: 532663614.40.1328102798583.JavaMail.omnix01@wlas1 (view raw or flat)
Thread:
Lists: pgadmin-support
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(at)lelarge(dot)info]
Wys?ane: Wednesday, February 1, 2012 09:58 AM
Do: bdmytrak(at)eranet(dot)pl
Kopia: pgadmin-support(at)postgresql(dot)org
Temat: Re: [pgadmin-support] Custom Auto Vacuum factors
On Wed, 2012-02-01 at 09:02 +0100, bdmytrak(at)eranet(dot)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?
--
Guillaume
http://blog.guillaume.lelarge.info
http://www.dalibo.com
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:
http://www.postgresql.org/mailpref/pgadmin-support

Responses

pgadmin-support by date

Next:From: Colin BeckinghamDate: 2012-02-02 20:11:59
Subject: Pgadmin3 : Opensuse 11.4 to 12.1 upgrade
Previous:From: Kieran McCuskerDate: 2012-02-01 10:51:32
Subject: Re: Performance of pgAdmin 14 Beta 2

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group