Home > mailing lists

autovacuum parameters - Mailing list pgadmin-support

From	Bartosz Dmytrak
Subject	autovacuum parameters
Date	March 20, 2012 08:03:15
Msg-id	CAD8_UcbaSP8wak3r_3ZMASUpktmkqtzJbvGsnmHU5eCRdHGCXw@mail.gmail.com Whole thread Raw
Responses	Re: autovacuum parameters (Guillaume Lelarge <guillaume@lelarge.info>)
List	pgadmin-support

Hi,

it is possible to set autovacuum_analyze_threshold and autovacuum_analyze_scale_factor for TOAST tables using pgAdmin.

Script generated is like this:

ALTER TABLE "MySchema"."MyTable" SET (

toast.autovacuum_analyze_threshold = 50,

toast.autovacuum_analyze_scale_factor = 0.1

);

according to doc http://www.postgresql.org/docs/9.1/static/sql-createtable.html#SQL-CREATETABLE-STORAGE-PARAMETERS there is no corresponding autovacuum_analyze_threshold and autovacuum_analyze_scale_factor for toast tables, and PG generates error when OK button is pressed - what is expected.

My suggestion is to disable/remove these options in Toast Table tab in Table Properties dialog.

BTW. When Custom autovacuum is enabled and there are no custom values set, then -1 is displayed - fields where empty in previous versions

Environment:

pgAdmin III 1.14.2 Win 7 32 bit

PG 9.1.3 MS Server 2008 R2 64 bit

Regards,
Bartek

From: MattK
Date: 19 March 2012, 19:27:00
Subject: Re: Server status hanging on OS X

From: Bartosz Dmytrak
Date: 20 March 2012, 08:06:24
Subject: Re: code completion feature question