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