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
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
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
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