Swapping in 7.4.3

From: "Jim Ewert" <jim(dot)ewert(at)excite(dot)com>
To: pgsql-performance(at)postgresql(dot)org
Subject: Swapping in 7.4.3
Date: 2004-07-12 16:59:05
Message-ID: 20040712165905.940A7395A@xprdmailfe9.nwk.excite.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance


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 before installation, however speed degaded to 1 *second* / update of one row in 150 rows of data, within a day! pg_autovacuum now gives excellent performance however it is taking 66M of swap; only 270k cached.

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

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Jan Wieck 2004-07-12 18:01:10 Re: Working on huge RAM based datasets
Previous Message Josh Berkus 2004-07-12 16:38:01 Re: Working on huge RAM based datasets