Re: [PERFORM] Pg+Linux swap use

2003-11-06 Thread Bruce Momjian
Greg Stark wrote: > > William Yu <[EMAIL PROTECTED]> writes: > > > Rob Sell wrote: > > > > > Not being one to hijack threads, but I haven't heard of this performance hit > > > when using HT, I have what should all rights be a pretty fast server, dual > > > 2.4 Xeons with HT 205gb raid 5 array, 1

Re: [PERFORM] Pg+Linux swap use

2003-11-02 Thread Greg Stark
William Yu <[EMAIL PROTECTED]> writes: > Rob Sell wrote: > > > Not being one to hijack threads, but I haven't heard of this performance hit > > when using HT, I have what should all rights be a pretty fast server, dual > > 2.4 Xeons with HT 205gb raid 5 array, 1 gig of memory. And it is only 50%

Re: [PERFORM] Pg+Linux swap use

2003-11-01 Thread William Yu
Rob Sell wrote: Not being one to hijack threads, but I haven't heard of this performance hit when using HT, I have what should all rights be a pretty fast server, dual 2.4 Xeons with HT 205gb raid 5 array, 1 gig of memory. And it is only 50% as fast as my old server which was a dual AMD MP 1400's w

Re: [PERFORM] Pg+Linux swap use

2003-10-31 Thread scott.marlowe
We had a problem at work that when a windows box would connect to a samba share with a lot of files in it, the kswapd was going nuts, even though we weren't low on memory at all. Updating to the 2.4.18 or so of the later redhats fixed that issue. It might be related. I think the kflush daemon

Re: [PERFORM] Pg+Linux swap use

2003-10-31 Thread Neil Conway
On Fri, 2003-10-31 at 11:37, Greg Stark wrote: > My understanding is that the case where HT hurts is precisely your case. When > you have two real processors with HT the kernel will sometimes schedule two > jobs on the two virtual processors on the same real processor leaving the two > virtual proc

Re: [PERFORM] Pg+Linux swap use

2003-10-31 Thread Andrew Sullivan
On Fri, Oct 31, 2003 at 10:42:06AM -0600, Rob Sell wrote: > For the record I am running on SuSE with a pretty much stock kernel. Not to > sound na?ve, but is turning of HT something done in the bios? As far as I know, yes. A -- Andrew Sullivan 204-4141 Yonge Street

Re: [PERFORM] Pg+Linux swap use

2003-10-31 Thread Bill Moran
Greg Stark wrote: Bill Moran <[EMAIL PROTECTED]> writes: Just for an additional viewpoint. I'm finishing up a project based on FreeBSD and PostgreSQL. The target server is a Dual 2.4G Intel machine. I have tested the application with hyperthreading enabled and disabled. To all appearances, ena

Re: [PERFORM] Pg+Linux swap use

2003-10-31 Thread Rob Sell
PROTECTED] Subject: Re: [PERFORM] Pg+Linux swap use Just for an additional viewpoint. I'm finishing up a project based on FreeBSD and PostgreSQL. The target server is a Dual 2.4G Intel machine. I have tested the application with hyperthreading enabled and disabled. To all appearances, ena

Re: [PERFORM] Pg+Linux swap use

2003-10-31 Thread Greg Stark
Bill Moran <[EMAIL PROTECTED]> writes: > Just for an additional viewpoint. I'm finishing up a project based on FreeBSD > and PostgreSQL. The target server is a Dual 2.4G Intel machine. I have tested > the application with hyperthreading enabled and disabled. To all appearances, > enabling hype

Re: [PERFORM] Pg+Linux swap use

2003-10-31 Thread Bill Moran
EMAIL PROTECTED] On Behalf Of Andrew Sullivan Sent: Friday, October 31, 2003 8:36 AM To: [EMAIL PROTECTED] Subject: Re: [PERFORM] Pg+Linux swap use On Fri, Oct 31, 2003 at 12:03:59PM -0200, alexandre :: aldeia digital wrote: Scott, Jeff and Shridhar: 1 GB RAM :) The stock kernels are not the same,

Re: [PERFORM] Pg+Linux swap use

2003-10-31 Thread Shridhar Daithankar
Jeff wrote: On Fri, 31 Oct 2003 09:31:19 -0600 "Rob Sell" <[EMAIL PROTECTED]> wrote: Not being one to hijack threads, but I haven't heard of this performance hit when using HT, I have what should all rights be a pretty fast server, dual 2.4 Xeons with HT 205gb raid 5 array, 1 gig of memory. And i

Re: [PERFORM] Pg+Linux swap use

2003-10-31 Thread Jeff
On Fri, 31 Oct 2003 09:31:19 -0600 "Rob Sell" <[EMAIL PROTECTED]> wrote: > Not being one to hijack threads, but I haven't heard of this > performance hit when using HT, I have what should all rights be a > pretty fast server, dual 2.4 Xeons with HT 205gb raid 5 array, 1 gig > of memory. And it is

Re: [PERFORM] Pg+Linux swap use

2003-10-31 Thread Rob Sell
lto:[EMAIL PROTECTED] On Behalf Of Andrew Sullivan Sent: Friday, October 31, 2003 8:36 AM To: [EMAIL PROTECTED] Subject: Re: [PERFORM] Pg+Linux swap use On Fri, Oct 31, 2003 at 12:03:59PM -0200, alexandre :: aldeia digital wrote: > Scott, Jeff and Shridhar: > > 1 GB RAM :) > > The

Re: [PERFORM] Pg+Linux swap use

2003-10-31 Thread Andrew Sullivan
On Fri, Oct 31, 2003 at 12:03:59PM -0200, alexandre :: aldeia digital wrote: > Scott, Jeff and Shridhar: > > 1 GB RAM :) > > The stock kernels are not the same, HyperThreading enabled. 80 Some people have reported that things actually slow down with HT enabled. Have you tried turning it off? A

Re: [PERFORM] Pg+Linux swap use

2003-10-31 Thread alexandre :: aldeia digital
Scott, Jeff and Shridhar: 1 GB RAM :) The stock kernels are not the same, HyperThreading enabled. 80 simultaneous connections. sort_mem = 4096 I will compile my own kernel on this weekend, and I will report to the list after. Thank's all Alexandre > Also are two kernels exactly same? In my e

Re: [PERFORM] Pg+Linux swap use

2003-10-31 Thread Shridhar Daithankar
Jeff wrote: On Thu, 30 Oct 2003 17:49:08 -0200 (BRST) "alexandre :: aldeia digital" <[EMAIL PROTECTED]> wrote: Both use: Only postgresql on server. Buffers = 8192, effective cache = 10 Well, I'm assuming you meant 1GB of ram, not 1MB :) Check a ps auxw to see what is running. Perhaps X is ru

Re: [PERFORM] Pg+Linux swap use

2003-10-31 Thread Jeff
On Thu, 30 Oct 2003 17:49:08 -0200 (BRST) "alexandre :: aldeia digital" <[EMAIL PROTECTED]> wrote: > Both use: Only postgresql on server. Buffers = 8192, effective cache = > 10 > Well, I'm assuming you meant 1GB of ram, not 1MB :) Check a ps auxw to see what is running. Perhaps X is runnin

Re: [PERFORM] Pg+Linux swap use

2003-10-30 Thread scott.marlowe
On Thu, 30 Oct 2003, alexandre :: aldeia digital wrote: > Hi, > > Old: Post 7.3.2, P4 1.8, 1 MB RAM, 2 x IDE SW RAID 1, RedHat 8 > New: Post 7.3.4, Xeon 2.4, 1 MB RAM, 2 x SCSI 15k SW RAID 1, RedHat 9 > > Both use: Only postgresql on server. Buffers = 8192, effective cache = 10 > > In old p

[PERFORM] Pg+Linux swap use

2003-10-30 Thread alexandre :: aldeia digital
Hi, Old: Post 7.3.2, P4 1.8, 1 MB RAM, 2 x IDE SW RAID 1, RedHat 8 New: Post 7.3.4, Xeon 2.4, 1 MB RAM, 2 x SCSI 15k SW RAID 1, RedHat 9 Both use: Only postgresql on server. Buffers = 8192, effective cache = 10 In old plataform the free and vmstat reports no use of swap. In new, the swap is