Date: Fri, 02 Sep 2005 09:23:44 +1000
To: pgsql-performance@postgresql.org
Subject: Re: lots of updates on small table
Message-ID: <43178D80.nail2T711S8W7@pluto.mirrabooka.com>
References: <42D5F34E.nail9QE1195IE@pluto.mirrabooka.com>
	<20050714162114.GA19778@alvh.no-ip.org>
	<42D6F854.nail3K81VIICH@pluto.mirrabooka.com>
	<5893.1121385447@sss.pgh.pa.us>
	<42D71EC1.nail8BK11QC2Q@pluto.mirrabooka.com>
In-Reply-To: <42D71EC1.nail8BK11QC2Q@pluto.mirrabooka.com>
User-Agent: nail 11.6 9/7/04
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
From: alison@mirrabooka.com (Alison Winters)

Just to dig up an old thread from last month:

In case anyone was wondering we finally got a free day to put in the new
version of the software, and it's greatly improved the performance.  The
solutions we employed were as follows:

- recompile everything with ecpg -t for auto-commit
- vacuum run by cron every 15 minutes
- vacuum full analyze AND a reindex of the table in question run by cron
  once per day

I also went through and double-checked everywhere where we opened a
cursor to make sure it was always closed when we were done.

This seems to have fixed up the endlessly growing indexes and slower and
slower updates.  Thanks to everyone who helped out.

Alison