Postgres Pro
Downloads
Home   >   mailing lists

Custom Auto Vacuum factors - Mailing list pgadmin-support

From bdmytrak@eranet.pl
Subject Custom Auto Vacuum factors
Date
Msg-id 1167977824.1654.1328083358545.JavaMail.omnix03@wlas3
Whole thread Raw
Responses Re: Custom Auto Vacuum factors
List pgadmin-support
Tree view
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

pgadmin-support by date:

Previous
From: Guillaume Lelarge
Date:
Subject: Re: column level privilages error
Next
From: Guillaume Lelarge
Date:
Subject: Re: Custom Auto Vacuum factors