Postgres Pro
Downloads
Home   >   mailing lists

Thread: autovacuum parameters

autovacuum parameters

From
Bartosz Dmytrak
Date:
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

Re: autovacuum parameters

From
Guillaume Lelarge
Date:
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

Re: autovacuum parameters

From
Bartosz Dmytrak
Date:



2012/3/20 Guillaume Lelarge <guillaume@lelarge.info>
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.
Thanks 

> 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?
I used to null values, -1 is strange, but still acceptable


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


Regards,
Bartek