[PERFORM] PostgreSQL not fully utilizing system resources?

2007-06-04 Thread Gregory Stewart
erver? Is our configuration flawed? Or are we already at a point where we need consider clustering / load balancing? Any ideas and suggestions are welcome. Regards, Gregory Stewart ---(end of broadcast)--- TIP 3: Have you checked our extensiv

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-02 Thread Gregory Stewart
Jim, Have you seen this happening only on W2k3? I am wondering if I should try out 2000 Pro or XP Pro. Not my first choice, but if it works... -Original Message- From: Jim C. Nasby [mailto:[EMAIL PROTECTED] Sent: Tuesday, May 02, 2006 3:29 PM To: Mark Kirkwood Cc: Gregory Stewart

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

[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