Re: Custom Auto Vacuum factors - Mailing list pgadmin-support

From bdmytrak@eranet.pl
Subject Re: Custom Auto Vacuum factors
Date
Msg-id 532663614.40.1328102798583.JavaMail.omnix01@wlas1
Whole thread Raw
In response to Custom Auto Vacuum factors  ("bdmytrak@eranet.pl" <bdmytrak@eranet.pl>)
Responses Re: Custom Auto Vacuum factors
List 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@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?


--
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@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgadmin-support

pgadmin-support by date:

Previous
From: Kieran McCusker
Date:
Subject: Re: Performance of pgAdmin 14 Beta 2
Next
From: Paul Morris
Date:
Subject: MACOSX Dropped Connection on Hibernate