From: | Larry Rosenman <ler(at)lerctr(dot)org> |
---|---|
To: | Steven Flatt <steven(dot)flatt(at)gmail(dot)com> |
Cc: | Francisco Reyes <lists(at)stringsutils(dot)com>, pgsql-performance(at)postgresql(dot)org |
Subject: | Re: Database-wide VACUUM ANALYZE |
Date: | 2007-06-21 19:59:53 |
Message-ID: | 20070621145901.M42326@thebighonker.lerctr.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-performance |
On Thu, 21 Jun 2007, Steven Flatt wrote:
> On 6/21/07, Francisco Reyes <lists(at)stringsutils(dot)com> wrote:
>>
>> Are you on FreeBSD by any chance?
>>
>> I think the FreeBSD port by default installs a script that does a daily
>> vacuum.
>
>
> Yes, FreeBSD. Do you know what script that is? And it does a db-wide
> VACUUM ANALYZE every day?! That is certainly not necessary, and in fact,
> costly for us.
>
> Hmmm... I wonder why this would just start now, three days ago. Everything
> seemed to be normal for the last two weeks.
>
The current FreeBSD port places the script in:
/usr/local/etc/periodic/daily/502.pgsql
And it can be controlled from /etc/periodic.conf
See the top of that script.
LER
> Steve
>
--
Larry Rosenman http://www.lerctr.org/~ler
Phone: +1 512-248-2683 E-Mail: ler(at)lerctr(dot)org
US Mail: 430 Valona Loop, Round Rock, TX 78681-3893
From | Date | Subject | |
---|---|---|---|
Next Message | Bill Moran | 2007-06-21 20:07:32 | Re: Database-wide VACUUM ANALYZE |
Previous Message | Chris Browne | 2007-06-21 19:52:24 | Re: Very long SQL strings |