Re: Performance Issues in 7.4.3

Hi,

On Wed, 30 Jun 2004 12:30:07 -0500 (EST)
Kris Jurka <books@ejurka.com> 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.

There also is a pgsql-performance@postgresql.org mailing list
specifically for performance questions.

HTH,
Markus


--
markus schaber | dipl. informatiker
logi-track ag | rennweg 14-16 | ch 8001 zürich
phone +41-43-888 62 52 | fax +41-43-888 62 53
mailto:schabios@logi-track.com | www.logi-track.com