Re: [GENERAL] slowness what only full vacuum can solve

2012-08-11 Thread Laszlo Fogas
Thank you for your answers, we will try to make it more agressive! On Aug 10, 2012 11:56 PM, "Bill Moran" wrote: > On Fri, 10 Aug 2012 16:14:54 +0200 Laszlo Fogas > wrote: > > > Sorry, I wasn't clear. > > > > Autovacuum runs with default setting, I beli

Re: [GENERAL] slowness what only full vacuum can solve

2012-08-10 Thread Laszlo Fogas
delay the event, but not prevent it. On Fri, Aug 10, 2012 at 3:49 PM, François Beausoleil wrote: > > Le 2012-08-10 à 07:53, Laszlo Fogas a écrit : > > We are running Postgres 8.3 on our production servers on Amazon EC2. > > > > We have a reoccurring problem of slowness in

[GENERAL] slowness what only full vacuum can solve

2012-08-10 Thread Laszlo Fogas
Hello guys, We are running Postgres 8.3 on our production servers on Amazon EC2. We have a reoccurring problem of slowness initially in every 2 months, after enabling autovacuum every 6 months what only full vacuum can solve. It's kind of a problem as it requires 2hrs downtime and we want to avoi