pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: Brad Nicholson <bnichols@ca.afilias.info>
To: Craig James <craig_james@emolecules.com>
Cc: Madison Kelly <linux@alteeve.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: DB is slow until DB is reloaded
Date: Tue, 05 Jan 2010 08:17:38 -0500
Message-ID: <1262697458.29852.6.camel@bnicholson-desktop> (raw)
In-Reply-To: <4B42B9C2.7050303@emolecules.com>
References: <4B423D22.7040803@alteeve.com>
	<4B424215.70605@pinpointresearch.com>
	<4B424FF6.40207@alteeve.com>
	<4B425222.7070905@gpdnet.co.uk>
	<4B425555.6020709@alteeve.com>
	<1262638856.29852.4.camel@bnicholson-desktop>
	<4B425E93.1050207@alteeve.com>
	<4B426359.9040601@pinpointresearch.com>
	<4B426438.40109@alteeve.com>
	<37d451f71001041406i3f5d8d5fte8a29cfbc06998c9@mail.gmail.com>
	<4B428917.3020305@alteeve.com>
	<4B42B9C2.7050303@emolecules.com>

On Mon, 2010-01-04 at 20:02 -0800, Craig James wrote:
> +Madison Kelly wrote:
> > 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. :)
>
> Most of the pain of a Postgres upgrade is the dump/reload step.  But you've already had to do that several times, so why the hesitation to upgrade?  Upgrading Postgres to the latest release, even if you have to do it from the source code, takes almost no time at all compared to the time you've already burned trying to solve this problem.  

Actually, the biggest pain going beyond 8.2 is the change to implicit
casting.  

> Do the upgrade, you won't regret it.

Agree.

-- 
Brad Nicholson  416-673-4106
Database Administrator, Afilias Canada Corp.





view thread (25+ messages)  latest in thread

Message-ID: <1262697458.29852.6.camel@bnicholson-desktop>
Permalink:  ../1262697458.29852.6.camel@bnicholson-desktop/
Also on:    postgresql.org/message-id/1262697458.29852.6.camel@bnicholson-desktop

 · 

reply
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: bnichols@ca.afilias.info, craig_james@emolecules.com, linux@alteeve.com
  Subject: Re: DB is slow until DB is reloaded
  In-Reply-To: <1262697458.29852.6.camel@bnicholson-desktop>

* 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