From: Greg Smith <greg@2ndquadrant.com>
To: Madison Kelly <linux@alteeve.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 17:13:55 -0500
Message-ID: <4B426823.4040001@2ndquadrant.com> (raw)
In-Reply-To: <4B42638B.4000103@alteeve.com>
References: <4B423D22.7040803@alteeve.com>
<4B424215.70605@pinpointresearch.com>
<4B424FF6.40207@alteeve.com>
<4B4260E6.7050502@pinpointresearch.com>
<4B42638B.4000103@alteeve.com>
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.
--
Greg Smith 2ndQuadrant Baltimore, MD
PostgreSQL Training, Services and Support
greg@2ndQuadrant.com www.2ndQuadrant.com
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: greg@2ndquadrant.com, linux@alteeve.com, scrawford@pinpointresearch.com
Subject: Re: DB is slow until DB is reloaded
In-Reply-To: <4B426823.4040001@2ndquadrant.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