Re: [PERFORM] Parameters for PostgreSQL

2011-08-04 Thread Craig Ringer
On 04/08/11 11:42, Jayadevan M wrote: > Hello, > > >The most important spec has been omitted. What's the storage subsystem? > We have storage on SAN, RAID 5. RAID 5? That's *really* not ideal for database workloads, either Pg or Oracle, unless your RAID 5 storage backend has enough battery-backed

Re: [PERFORM] Parameters for PostgreSQL

2011-08-04 Thread Andy Colson
On 8/3/2011 11:03 PM, Craig Ringer wrote: great gobs of battery backed write cache DRAM. Now I know what I'm asking Santa for Christmas this year! -Andy -- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription: http://www.postgresql.

Re: [PERFORM] Parameters for PostgreSQL

2011-08-03 Thread Adarsh Sharma
I think RAID 10 is best among all the RAID Levels. Thanks Craig Ringer wrote: On 04/08/11 11:42, Jayadevan M wrote: Hello, >The most important spec has been omitted. What's the storage subsystem? We have storage on SAN, RAID 5. RAID 5? That's *really* not ideal for database workloads, eit

Re: [PERFORM] Parameters for PostgreSQL

2011-08-03 Thread Craig Ringer
On 04/08/11 11:42, Jayadevan M wrote: > Hello, > > >The most important spec has been omitted. What's the storage subsystem? > We have storage on SAN, RAID 5. RAID 5? That's *really* not ideal for database workloads, either Pg or Oracle, unless your RAID 5 storage backend has enough battery-backed

Re: [PERFORM] Parameters for PostgreSQL

2011-08-03 Thread Jayadevan M
Hello, >The most important spec has been omitted. What's the storage subsystem? We have storage on SAN, RAID 5. > > We are suing weblogic. > ^ > Best. Typo. Ever. > > I hear most people who use it want to, you're just brave enough to do it :-P I wish I could make a few millions

Re: [PERFORM] Parameters for PostgreSQL

2011-08-01 Thread Craig Ringer
On 1/08/2011 8:09 PM, Jayadevan M wrote: The machine configuration is Opteron 2CPU * 4cores @ 2.3GHz 16GB RAM OS Solaris10 x64 The most important spec has been omitted. What's the storage subsystem? For most database workloads that's *WAY* more important than the CPUs. It certainly will be

Re: [PERFORM] Parameters for PostgreSQL

2011-08-01 Thread Merlin Moncure
On Mon, Aug 1, 2011 at 7:09 AM, Jayadevan M wrote: > Hello all, > We are planning to test one of our products, which works with Oracle, on > PostgreSQL.  The database size is about 100 GB. It is a product with a > not-so-high load ( about 10 tps - mostly read). My doubts are about > PostgreSQL set

[PERFORM] Parameters for PostgreSQL

2011-08-01 Thread Jayadevan M
Hello all, We are planning to test one of our products, which works with Oracle, on PostgreSQL. The database size is about 100 GB. It is a product with a not-so-high load ( about 10 tps - mostly read). My doubts are about PostgreSQL settings. For Oracle, we give about 4 GB SGA (shared buffer)