pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedFilesystem and PG configuration
4+ messages / 4 participants
[nested] [flat]
* Filesystem and PG configuration
@ 2010-06-04 15:25 RBN <rbn.ggl@gmail.com>
0 siblings, 2 replies; 4+ messages in thread
From: RBN @ 2010-06-04 15:25 UTC (permalink / raw)
To: pgsql-admin
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 considering changing to xfs. I'm not sure what block size to use for
the file system, is 8192 appropriate? The OS page size is 4096.
The database is both write and read intensive, with about 750MB of new data
added per week and old deleted every six months to one year.
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: Filesystem and PG configuration
@ 2010-06-05 01:53 Anh Ky Huynh <xkyanh@gmail.com>
parent: RBN <rbn.ggl@gmail.com>
1 sibling, 1 reply; 4+ messages in thread
From: Anh Ky Huynh @ 2010-06-05 01:53 UTC (permalink / raw)
To: RBN <rbn.ggl@gmail.com>; +Cc: pgsql-admin
On Fri, 4 Jun 2010 11:25:55 -0400
RBN <rbn.ggl@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 SSDs RAID 10 using jfs with 8
> drives active and 1 as spare.
>
> I'm considering changing to xfs. I'm not sure what block size to
> use for the file system, is 8192 appropriate? The OS page size is
> 4096.
>
> The database is both write and read intensive, with about 750MB of
> new data added per week and old deleted every six months to one
> year.
A good start:
Tuning: http://www.westnet.com/~gsmith/content/postgresql/pgbench-scaling.htm
Benchmark: http://edoceo.com/liber/db-postgresql-benchmark
Here's my benchmark on `m1.medium` instance of Amazon EC2:
http://gx.viettug.org/zen/kyanh/jobs/pgbench0.jpg.html
Good luck,
--
Anh Ky Huynh
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: Filesystem and PG configuration
@ 2010-06-07 06:31 Andreas Schmitz <mailinglist@longimanus.net>
parent: RBN <rbn.ggl@gmail.com>
1 sibling, 0 replies; 4+ messages in thread
From: Andreas Schmitz @ 2010-06-07 06:31 UTC (permalink / raw)
To: RBN <rbn.ggl@gmail.com>; +Cc: pgsql-admin
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 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 considering changing to xfs. I'm not sure what block size to use
> for the file system, is 8192 appropriate? The OS page size is 4096.
>
> The database is both write and read intensive, with about 750MB of new
> data added per week and old deleted every six months to one year.
>
>
>
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: Filesystem and PG configuration
@ 2010-06-09 18:45 Greg Spiegelberg <gspiegelberg@gmail.com>
parent: Anh Ky Huynh <xkyanh@gmail.com>
0 siblings, 0 replies; 4+ messages in thread
From: Greg Spiegelberg @ 2010-06-09 18:45 UTC (permalink / raw)
To: Anh Ky Huynh <xkyanh@gmail.com>; +Cc: RBN <rbn.ggl@gmail.com>; pgsql-admin
On Fri, Jun 4, 2010 at 7:53 PM, Anh Ky Huynh <xkyanh@gmail.com> wrote:
>
> A good start:
>
> Tuning:
> http://www.westnet.com/~gsmith/content/postgresql/pgbench-scaling.htm<http://www.westnet.com/%7Eg...;
> Benchmark: http://edoceo.com/liber/db-postgresql-benchmark
>
> Here's my benchmark on `m1.medium` instance of Amazon EC2:
> http://gx.viettug.org/zen/kyanh/jobs/pgbench0.jpg.html
>
>
Anh,
Were you using a EBS device in EC2 for that benchmark?
-Greg
^ permalink raw reply [nested|flat] 4+ messages in thread
end of thread, other threads:[~2010-06-09 18:45 UTC | newest]
Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2010-06-04 15:25 Filesystem and PG configuration RBN <rbn.ggl@gmail.com>
2010-06-05 01:53 ` Anh Ky Huynh <xkyanh@gmail.com>
2010-06-09 18:45 ` Greg Spiegelberg <gspiegelberg@gmail.com>
2010-06-07 06:31 ` Andreas Schmitz <mailinglist@longimanus.net>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox