Re: query is taking longer time after a while - Mailing list pgsql-general

From Bill Moran
Subject Re: query is taking longer time after a while
Date
Msg-id 20090930083044.c79b92e5.wmoran@potentialtech.com
Whole thread Raw
In response to Re: query is taking longer time after a while  (tomrevam <tomer@fabrix.tv>)
Responses Re: query is taking longer time after a while  (tomrevam <tomer@fabrix.tv>)
List pgsql-general
In response to tomrevam <tomer@fabrix.tv>:
>

My apologies, I should have asked for the output of VACUUM VERBOSE on
the problem table in conjunction with these settings.  (make sure you
do VACUUM VERBOSE when the table is exhibiting the speed problem)

>
> Bill Moran wrote:
> >
> > The OP did mention that he's using autovac, which will take care of
> > both vacuum and analyze for him.  However, he didn't provide his
> > autovac config, and it happens at times that the defaults are not
> > aggressive enough to keep a table well-maintained.
> >
>
> Here are my autovac configuration parameters. I played around with them to
> make autovac work frequently.
>
> #autovacuum = on
> log_autovacuum_min_duration = 0
> autovacuum_max_workers = 10
> autovacuum_naptime = 10s
> autovacuum_vacuum_threshold = 2000
> autovacuum_analyze_threshold = 2000
> autovacuum_vacuum_scale_factor = 0.0005
> autovacuum_analyze_scale_factor = 0.0005
> #autovacuum_freeze_max_age = 200000000
> #autovacuum_vacuum_cost_delay = 20
> --
> View this message in context:
http://www.nabble.com/query-is-taking-longer-time-after-a-while-tp25661219p25675635.html
> Sent from the PostgreSQL - general mailing list archive at Nabble.com.
>
>
> --
> Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general


--
Bill Moran
http://www.potentialtech.com
http://people.collaborativefusion.com/~wmoran/

pgsql-general by date:

Previous
From: Devrim GÜNDÜZ
Date:
Subject: Re: Postgresql Web Hosting
Next
From: Bill Moran
Date:
Subject: Re: query is taking longer time after a while