Performance Issues in 7.4.3

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?




_______________________________________________
Join Excite! - http://www.excite.com
The most personalized portal on the Web!