Re: Performance Issues in 7.4.3

On Wed, 30 Jun 2004, Jim Ewert wrote:

>
> My previous post about slow updates w/ 7.4.2 needed a multi-column index
> to get speed comparable to Sybase.  When I went to 7.4.3 (Slackware 9.1)
> w/ JDBC, the improvements are that it doesn't initially take much memory
> (have 512M) and didn't swap.  I ran a full vaccum and a cluster, however
> speed degaded to 1 *second* / update of one row in 150 rows of data,
> within a day!  pg_autovacuum now gives excellent performance.  What
> happened?
>

This is not a jdbc question and is probably more appropriate for the
-general list.

http://www.postgresql.org/docs/7.4/static/maintenance.html#VACUUM-FOR-SPACE-RECOVERY

Kris Jurka