Custom Auto Vacuum factors

From: "bdmytrak(at)eranet(dot)pl" <bdmytrak(at)eranet(dot)pl>
To: pgadmin-support(at)postgresql(dot)org
Subject: Custom Auto Vacuum factors
Date: 2012-02-01 08:02:38
Message-ID: 1167977824.1654.1328083358545.JavaMail.omnix03@wlas3
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-support

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

Responses

Browse pgadmin-support by date

  From Date Subject
Next Message Guillaume Lelarge 2012-02-01 08:57:37 Re: Custom Auto Vacuum factors
Previous Message Paul Morris 2012-02-01 00:51:55 MACOSX Dropped Connection on Hibernate