From: | Jim Longwill <JLongwill(at)psmfc(dot)org> |
---|---|
To: | <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Configure Different Databases on One Server |
Date: | 2015-11-02 19:08:04 |
Message-ID: | 5637B494.3060806@psmfc.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Thanks to Mr. Nasby & others for these references & input.
Indeed. I'm rather sure we don't have tables updated heavily enough to
warrant any adjustments to autovacuum, or to do extra 'vacuuming' of the
database. So I'll be leaving it alone (i.e. there's nothing broke so no
fixes needed!)
--Jim :^)
On 10/30/2015 11:52 AM, Jim Nasby wrote:
> On 10/29/15 5:01 PM, Thomas Kellerer wrote:
>> So no harm in keeping it enabled - plus this smells like premature
>> optimization.
>> I would not touch this unless you _really_ see a performance problem
>> that is cause by autovacuum on that database.
>
> Moreso, if you think the problem is autovacuum (in this case) it's
> probably something else.
>
> If I can toot my own horn, you might want to watch the recording of
> http://www.pgcon.org/2015/schedule/events/829.en.html.
--
--o--o--o--o--o--o--o--o--o--o--o--o--
Jim Longwill
JLongwill(at)psmfc(dot)org
--o--o--o--o--o--o--o--o--o--o--o--o--
From | Date | Subject | |
---|---|---|---|
Next Message | Sami Pietilä | 2015-11-02 21:09:58 | How to search a string inside a json structure |
Previous Message | Paul Jungwirth | 2015-11-02 18:59:51 | Re: pg_archivecleanup not deleting anything? |