| From: | Bartosz Dmytrak <bdmytrak(at)eranet(dot)pl> |
|---|---|
| To: | PgAdmin Support <pgadmin-support(at)postgresql(dot)org> |
| Subject: | autovacuum parameters |
| Date: | 2012-03-20 08:02:18 |
| Message-ID: | CAD8_UcbaSP8wak3r_3ZMASUpktmkqtzJbvGsnmHU5eCRdHGCXw@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | 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 | Date | Subject | |
|---|---|---|---|
| Next Message | Bartosz Dmytrak | 2012-03-20 08:05:28 | Re: code completion feature question |
| Previous Message | MattK | 2012-03-19 19:26:43 | Re: Server status hanging on OS X |