Re: [PERFORM] High Load on Postgres 7.4.16 Server

aring about what other people on the list have there kernel tuned too. Best Regards John Allgood -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Dave Cramer Sent: Thursday, April 05, 2007 4:27 PM To: John Allgood Cc: 'Jeff Frost'; pg

Re: [PERFORM] High Load on Postgres 7.4.16 Server

Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Dave Cramer Sent: Thursday, April 05, 2007 4:01 PM To: John Allgood Cc: 'Jeff Frost'; pgsql-performance@postgresql.org Subject: Re: [PERFORM] High Load on Postgres 7.4.16 Server On 5-Apr-07, at 3:33 PM, John All

Re: [PERFORM] High Load on Postgres 7.4.16 Server

what about kernel buffers on RHEL4. Thanks -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Jeff Frost Sent: Thursday, April 05, 2007 3:24 PM To: John Allgood Cc: pgsql-performance@postgresql.org Subject: Re: [PERFORM] High Load on Postgres 7.4.16 Server

[PERFORM] High Load on Postgres 7.4.16 Server

Hello All I sent this message to the admin list and it never got through so I am trying the performance list. We moved our application to a new machine last night. It is a Dell PowerEdge 6950 2X Dual Core. AMD Opteron 8214 2.2Ghz. 8GB Memory. The machine is running R

[PERFORM] Peformance Tuning Opterons/ Hard Disk Layout

g_xlog for database group 2 MIRROR5 - Database Group 3 MIRROR6 - pg_xlog for database group 3 This will take about 12 disk drives. I have a 14 bay Storage Bay I can use two of the drives for hotspare's. Thanks John Allgood - ESC Systems Administrator ---(end of broadcast

Re: [PERFORM] Peformance Tuning Opterons/ Hard Disk Layout

rrectly, and will restart them automatically if they fail. John Arbash Meinel wrote: John Allgood wrote: This some good info. The type of attached storage is a Kingston 14 bay Fibre Channel Infostation. I have 14 36GB 15,000 RPM drives. I think the way it is being explained that I should build a

Re: [PERFORM] Peformance Tuning Opterons/ Hard Disk Layout

into one cluster. Also I might mention that I am running clustering using Redhat Clustering Suite. John Arbash Meinel wrote: John Allgood wrote: I think maybe I didn't explain myself well enough. At most we will service 200-250 connections across all the 9 databases mentioned. The database w

Re: [PERFORM] Peformance Tuning Opterons/ Hard Disk Layout

hanks John Allgood - ESC Tom Lane wrote: "Bruno Almeida do Lago" <[EMAIL PROTECTED]> writes: Is there a real limit for max_connections? Here we've an Oracle server with up to 1200 simultaneous conections over it! [ shrug... ] If your machine has the beef to run 1200 simulta

[PERFORM] Peformance Tuning Opterons/ Hard Disk Layout

plish the best performance or would it be better to use all the drives in one huge raid five with a couple of failovers. I have looked around in the archives and found some info but I would like to here about some of the configs other people are running and how they have them setup. Thanks John Al

[PERFORM] Database Server Tuning

WAL on to separate drives which will be mirrored. I am looking for input on setting kernel parameters, and Postgres server runtime parameters and other settings relating to tuning. Also is there any benchmarking tools available that will help me tune this server. Thanks John Allgood - ESC System Adm

Re: [PERFORM] Database Server Tuning

what you get under heavy load for context-switching. We've been having issues with RH+Xeon with really large queries. This is exactly what I was looking for. I will keep you posted on what kinda results I get when I start putting a load on this server. Thanks John Allgood - E