From: alison@mirrabooka.com
To: pgsql-performance@postgresql.org
Subject: Re: lots of updates on small table
Date: Fri, 02 Sep 2005 09:23:44 +1000
Message-ID: <43178D80.nail2T711S8W7@pluto.mirrabooka.com> (raw)
In-Reply-To: <42D71EC1.nail8BK11QC2Q@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>
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
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: alison@mirrabooka.com
Subject: Re: lots of updates on small table
In-Reply-To: <43178D80.nail2T711S8W7@pluto.mirrabooka.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