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

Re: autovacuum parameters

From: Guillaume Lelarge <guillaume(at)lelarge(dot)info>
To: Bartosz Dmytrak <bdmytrak(at)eranet(dot)pl>
Cc: PgAdmin Support <pgadmin-support(at)postgresql(dot)org>
Subject: Re: autovacuum parameters
Date: 2012-03-20 21:00:56
Message-ID: 1332277256.3562.32.camel@localhost.localdomain (view raw or flat)
Thread:
Lists: pgadmin-support
On Tue, 2012-03-20 at 09:02 +0100, Bartosz Dmytrak wrote:
> 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.
> 

Fixed by removing these options.

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

Which is better, no?


-- 
Guillaume
http://blog.guillaume.lelarge.info
http://www.dalibo.com


In response to

Responses

pgadmin-support by date

Next:From: Bartosz DmytrakDate: 2012-03-20 21:49:06
Subject: Re: autovacuum parameters
Previous:From: Guillaume LelargeDate: 2012-03-20 20:13:26
Subject: Re: Server status hanging on OS X

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