| 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 |
| Thread: | |
| 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
--
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(at)logi-track(dot)com | www.logi-track.com
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Oliver Jowett | 2004-07-01 11:20:58 | Re: Query was cancelled - reason? |
| Previous Message | Guido Fiala | 2004-07-01 08:53:00 | Query was cancelled - reason? |