Re: [PERFORM] Swapping in 7.4.3

2004-07-16 Thread Matt Clark
> This is normal. My personal workstation has been up for 16 > days, and it shows 65 megs used for swap. The linux kernel > looks for things that haven't been accessed in quite a while > and tosses them into swap to free up the memory for other uses. > > This isn't PostgreSQL's fault, or anyt

Re: [PERFORM] Swapping in 7.4.3

2004-07-15 Thread Scott Marlowe
decreases according to top. > > --- On Tue 07/13, Matthew T. O'Connor < [EMAIL PROTECTED] > wrote: > From: Matthew T. O'Connor [mailto: [EMAIL PROTECTED] > To: [EMAIL PROTECTED] > Cc: [EMAIL PROTECTED] > Date: Tue, 13 Jul 2004 16:26:09 -0400 > Subjec

Re: [PERFORM] Swapping in 7.4.3

2004-07-15 Thread Jim Ewert
IL PROTECTED] Cc: [EMAIL PROTECTED] Date: Tue, 13 Jul 2004 16:26:09 -0400 Subject: Re: [PERFORM] Swapping in 7.4.3 Jim Ewert wrote:> 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

Re: [PERFORM] Swapping in 7.4.3

2004-07-13 Thread Matthew T. O'Connor
Jim Ewert wrote: 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

[PERFORM] Swapping in 7.4.3

2004-07-13 Thread Jim Ewert
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_autovac