| From: | Madison Kelly <linux(at)alteeve(dot)com> |
|---|---|
| To: | Rosser Schwarz <rosser(dot)schwarz(at)gmail(dot)com> |
| Cc: | Steve Crawford <scrawford(at)pinpointresearch(dot)com>, Brad Nicholson <bnichols(at)ca(dot)afilias(dot)info>, Gary Doades <gpd(at)gpdnet(dot)co(dot)uk>, pgsql-performance(at)postgresql(dot)org |
| Subject: | Re: DB is slow until DB is reloaded |
| Date: | 2010-01-05 00:34:31 |
| Message-ID: | 4B428917.3020305@alteeve.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
Rosser Schwarz wrote:
> On Mon, Jan 4, 2010 at 2:57 PM, Madison Kelly <linux(at)alteeve(dot)com> wrote:
>> As for autovacuum, I assumed (yes, I know) that all v8.x releases enabled it
>> by default. How would I confirm that it's running or not?
>
> I believe it's not enabled by default in 8.1-land, and is as of 8.2
> and later. Whether it's running or not, try "SELECT * FROM
> pg_autovacuum;". If that returns the null set, it's not doing
> anything, as it hasn't been told it has anything to do.
>
> IME, however, if you really want to benefit from the autovacuum
> daemon, you probably do want to be on something more recent than 8.1.
> (And, yes, this is a bit of the pot calling the kettle black: I have a
> mixed set of 8.1 and 8.3 hosts. Autovacuum is only running on the
> latter, while the former are queued for an upgrade.)
>
> rls
You are right, autovacuum is not running after all. From your comment, I
am wondering if you'd recommend I turn it on or not? If so, given that I
doubt I will upgrade any time soon, how would I enable it? I suppose I
could google that, but google rarely shares gotcha's. :)
Madi
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Madison Kelly | 2010-01-05 00:36:03 | Re: DB is slow until DB is reloaded |
| Previous Message | Erik Jones | 2010-01-04 23:13:43 | Re: forced sequential scan when condition has current_user |