Quick Links

Re: Performance Issues in 7.4.3

Lists:	pgsql-jdbc

From:	"Jim Ewert" <jim(dot)ewert(at)excite(dot)com>
To:	pgsql-jdbc(at)postgresql(dot)org
Subject:	Performance Issues in 7.4.3
Date:	2004-06-30 13:45:58
Message-ID:	20040630134558.4A0403949@xprdmailfe9.nwk.excite.com
Views:	Raw Message \| Whole Thread \| Download mbox \| Resend email
Lists:	pgsql-jdbc

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!

From:	Kris Jurka <books(at)ejurka(dot)com>
To:	Jim Ewert <jim(dot)ewert(at)excite(dot)com>
Cc:	pgsql-jdbc(at)postgresql(dot)org
Subject:	Re: Performance Issues in 7.4.3
Date:	2004-06-30 17:30:07
Message-ID:	Pine.BSO.4.56.0406301224590.20855@leary.csoft.net
Views:	Raw Message \| Whole Thread \| Download mbox \| Resend email
Lists:	pgsql-jdbc

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

From:	Markus Schaber <schabios(at)logi-track(dot)com>
To:	Kris Jurka <books(at)ejurka(dot)com>
Cc:	Jim Ewert <jim(dot)ewert(at)excite(dot)com>, pgsql-jdbc(at)postgresql(dot)org
Subject:	Re: Performance Issues in 7.4.3
Date:	2004-07-01 10:03:29
Message-ID:	20040701120329.2a78fac3@kingfisher.intern.logi-track.com
Views:	Raw Message \| Whole Thread \| Download mbox \| Resend email
Lists:	pgsql-jdbc

Hi,

On Wed, 30 Jun 2004 12:30:07 -0500 (EST)
Kris Jurka <books(at)ejurka(dot)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(at)postgresql(dot)org mailing list
specifically for performance questions.

HTH,
Markus