Re: [ADMIN] Filesystem and PG configuration

2010-06-09 Thread Greg Spiegelberg
On Fri, Jun 4, 2010 at 7:53 PM, Anh Ky Huynh xky...@gmail.com wrote: A good start: Tuning: http://www.westnet.com/~gsmith/content/postgresql/pgbench-scaling.htmhttp://www.westnet.com/%7Egsmith/content/postgresql/pgbench-scaling.htm Benchmark: http://edoceo.com/liber/db-postgresql-benchmark

Re: [ADMIN] Filesystem and PG configuration

2010-06-07 Thread Andreas Schmitz
Hi, pgtune could be the thing you're looking for. http://pgfoundry.org/projects/pgtune/ regards andreas RBN wrote: Can someone suggest some appropriate initial configuration parameters and shared memory settings for the following hardware? I'm running Debian on a Dell with 4x6 core

[ADMIN] Filesystem and PG configuration

2010-06-04 Thread RBN
Can someone suggest some appropriate initial configuration parameters and shared memory settings for the following hardware? I'm running Debian on a Dell with 4x6 core CPU and 128GB memory and writing to a coraid with 9 x 32GB SSDs RAID 10 using jfs with 8 drives active and 1 as spare. I'm

Re: [ADMIN] Filesystem and PG configuration

2010-06-04 Thread Anh Ky Huynh
On Fri, 4 Jun 2010 11:25:55 -0400 RBN rbn@gmail.com wrote: Can someone suggest some appropriate initial configuration parameters and shared memory settings for the following hardware? I'm running Debian on a Dell with 4x6 core CPU and 128GB memory and writing to a coraid with 9 x 32GB