Re: [pgadmin-support] autovacuum parameters

2012-03-20 Thread Bartosz Dmytrak
2012/3/20 Guillaume Lelarge > 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

Re: [pgadmin-support] autovacuum parameters

2012-03-20 Thread Guillaume Lelarge
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_thresh

[pgadmin-support] autovacuum parameters

2012-03-20 Thread Bartosz Dmytrak
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