Re: [PERFORM] Performance Issues on Opteron Dual Core

2006-05-09 Thread Gregory Stewart
/ session / query? Gregory -Original Message- From: Jim C. Nasby [mailto:[EMAIL PROTECTED] Sent: Thursday, May 04, 2006 12:47 PM To: Gregory Stewart Cc: Mark Kirkwood; pgsql-performance@postgresql.org Subject: Re: [PERFORM] Performance Issues on Opteron Dual Core All the machines I&#x

Re: [PERFORM] Performance Issues on Opteron Dual Core

2006-05-05 Thread Magnus Hagander
> > > > > FWIW, I've found problems running PostgreSQL on Windows in a > > > > > multi-CPU environment on w2k3. It runs fine for some > period, and > > > > > then CPU and throughput drop to zero. So far I've > been unable to > > > > > track down any more information than that, other than the >

Re: [PERFORM] Performance Issues on Opteron Dual Core

2006-05-04 Thread Jim C. Nasby
On Wed, May 03, 2006 at 09:29:15AM +0200, Magnus Hagander wrote: > > > > FWIW, I've found problems running PostgreSQL on Windows in a > > > > multi-CPU environment on w2k3. It runs fine for some period, and > > > > then CPU and throughput drop to zero. So far I've been unable to > > > > track do

Re: [PERFORM] Performance Issues on Opteron Dual Core

2006-05-04 Thread Jim C. Nasby
> > > -Original Message- > From: Jim C. Nasby [mailto:[EMAIL PROTECTED] > Sent: Tuesday, May 02, 2006 3:29 PM > To: Mark Kirkwood > Cc: Gregory Stewart; pgsql-performance@postgresql.org > Subject: Re: [PERFORM] Performance Issues on Opteron Dual Core > > > On

Re: [PERFORM] Performance Issues on Opteron Dual Core

2006-05-03 Thread Jan de Visser
On Wednesday 03 May 2006 03:29, Magnus Hagander wrote: > > > > FWIW, I've found problems running PostgreSQL on Windows in a > > > > multi-CPU environment on w2k3. It runs fine for some period, and > > > > then CPU and throughput drop to zero. So far I've been unable to > > > > track down any more i

Re: [PERFORM] Performance Issues on Opteron Dual Core

2006-05-03 Thread Magnus Hagander
> > > FWIW, I've found problems running PostgreSQL on Windows in a > > > multi-CPU environment on w2k3. It runs fine for some period, and > > > then CPU and throughput drop to zero. So far I've been unable to > > > track down any more information than that, other than the > fact that > > > I h

Re: [PERFORM] Performance Issues on Opteron Dual Core

2006-05-02 Thread Gregory Stewart
; pgsql-performance@postgresql.org Subject: Re: [PERFORM] Performance Issues on Opteron Dual Core On Sun, Apr 30, 2006 at 10:59:56PM +1200, Mark Kirkwood wrote: > Pgadmin can give misleading times for queries that return large result > sets over a network, due to: > > 1/ It takes time t

Re: [PERFORM] Performance Issues on Opteron Dual Core

2006-05-02 Thread Gregory Stewart
software I guess. But I don't really know a whole lot about it. -Original Message- From: Mark Kirkwood [mailto:[EMAIL PROTECTED] Sent: Sunday, April 30, 2006 7:04 PM To: Gregory Stewart Cc: Theodore Loscalzo Subject: Re: [PERFORM] Performance Issues on Opteron Dual Core Gregory Stewart wr

Re: [PERFORM] Performance Issues on Opteron Dual Core

2006-05-02 Thread Jim C. Nasby
On Tue, May 02, 2006 at 06:49:48PM -0400, Jan de Visser wrote: > On Tuesday 02 May 2006 16:28, Jim C. Nasby wrote: > > On Sun, Apr 30, 2006 at 10:59:56PM +1200, Mark Kirkwood wrote: > > > Pgadmin can give misleading times for queries that return large result > > > sets over a network, due to: > > >

Re: [PERFORM] Performance Issues on Opteron Dual Core

2006-05-02 Thread Jan de Visser
On Tuesday 02 May 2006 16:28, Jim C. Nasby wrote: > On Sun, Apr 30, 2006 at 10:59:56PM +1200, Mark Kirkwood wrote: > > Pgadmin can give misleading times for queries that return large result > > sets over a network, due to: > > > > 1/ It takes time to format the (large) result set for display. > > 2

Re: [PERFORM] Performance Issues on Opteron Dual Core

2006-05-02 Thread Jim C. Nasby
On Sun, Apr 30, 2006 at 10:59:56PM +1200, Mark Kirkwood wrote: > Pgadmin can give misleading times for queries that return large result > sets over a network, due to: > > 1/ It takes time to format the (large) result set for display. > 2/ It has to count the time spent waiting for the (large) res

Re: [PERFORM] Performance Issues on Opteron Dual Core

2006-04-30 Thread Mark Kirkwood
Gregory Stewart wrote: Hello, We are currently developing a web application and have the webserver and PostgreSQL with our dev db running on a machine with these specs: Win 2003 standard AMD Athlon XP 3000 / 2.1 GHZ 2 Gig ram 120 gig SATA HD PostgreSQL 8.1.0 Default pgsql configuration + shar

[PERFORM] Performance Issues on Opteron Dual Core

2006-04-29 Thread Gregory Stewart
Hello, We are currently developing a web application and have the webserver and PostgreSQL with our dev db running on a machine with these specs: Win 2003 standard AMD Athlon XP 3000 / 2.1 GHZ 2 Gig ram 120 gig SATA HD PostgreSQL 8.1.0 Default pgsql configuration + shared buffers = 30,000 The p