From: Madison Kelly <linux@alteeve.com>
To: Scott Marlowe <scott.marlowe@gmail.com>
Cc: Greg Smith <greg@2ndquadrant.com>
Cc: Steve Crawford <scrawford@pinpointresearch.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: DB is slow until DB is reloaded
Date: Mon, 04 Jan 2010 19:36:03 -0500
Message-ID: <4B428973.1000401@alteeve.com> (raw)
In-Reply-To: <dcc563d11001041451l326c694bp736aa7019cda8d11@mail.gmail.com>
References: <4B423D22.7040803@alteeve.com>
<4B424215.70605@pinpointresearch.com>
<4B424FF6.40207@alteeve.com>
<4B4260E6.7050502@pinpointresearch.com>
<4B42638B.4000103@alteeve.com>
<4B426823.4040001@2ndquadrant.com>
<dcc563d11001041451l326c694bp736aa7019cda8d11@mail.gmail.com>
Scott Marlowe wrote:
> On Mon, Jan 4, 2010 at 3:13 PM, Greg Smith <greg@2ndquadrant.com> wrote:
>> Madison Kelly wrote:
>>> I think for now, I will stick with 8.1, but I will certainly try out your
>>> repo edit above on a test machine and see how that works out. I am always
>>> reticent to change something as fundamental as postgres without "good
>>> reason". I guess I am a fan of "if it ain't broke...". :)
>> PostgreSQL has many fundamental limitations that cannot be resolved no
>> matter what you do in 8.1 that are fixed in later versions. The default
>> behavior for the problem you're having has been massively improved by
>> updates made in 8.2, 8.3, and 8.4. 8.1 can certainly be considered broken
>> in regards to its lack of good and automatic VACUUM and ANALYZE behavior,
>> and you're just seeing the first round of issues in that area. Every minute
>> you spend applying temporary fixes to the fundamental issues is time you
>> could be better spending toward upgrading instead.
>
> Also, the HOT updates in 8.3 made a compelling case for us to update,
> and if the OP is suffering from table bloat, HOT might help a lot.
>
These are certainly compelling reasons for me to try upgrading... I will
try a test upgrade on a devel server tomorrow using Steve's repo edits.
Madi
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: linux@alteeve.com, scott.marlowe@gmail.com, greg@2ndquadrant.com, scrawford@pinpointresearch.com
Subject: Re: DB is slow until DB is reloaded
In-Reply-To: <4B428973.1000401@alteeve.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox