From: | Bartosz Dmytrak <bdmytrak(at)eranet(dot)pl> |
---|---|
To: | Guillaume Lelarge <guillaume(at)lelarge(dot)info> |
Cc: | PgAdmin Support <pgadmin-support(at)postgresql(dot)org> |
Subject: | Re: autovacuum parameters |
Date: | 2012-03-20 21:49:06 |
Message-ID: | CAD8_UcYvz5x2iAvvAUrBh_ZcT0k++L=d8mwB44izAROxz-Tk4Q@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgadmin-support |
2012/3/20 Guillaume Lelarge <guillaume(at)lelarge(dot)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
From | Date | Subject | |
---|---|---|---|
Next Message | MrTeeth | 2012-03-20 21:58:37 | Creating relationship links in PostgreSQL via pgAdmin |
Previous Message | Guillaume Lelarge | 2012-03-20 21:00:56 | Re: autovacuum parameters |