| From: | Andreas Schmitz <mailinglist(at)longimanus(dot)net> |
|---|---|
| To: | RBN <rbn(dot)ggl(at)gmail(dot)com> |
| Cc: | pgsql-admin(at)postgresql(dot)org |
| Subject: | Re: Filesystem and PG configuration |
| Date: | 2010-06-07 06:31:11 |
| Message-ID: | 4C0C922F.6010306@longimanus.net |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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.
>
>
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Matthew Excell | 2010-06-07 19:33:27 | Clearing locks |
| Previous Message | Samuel Stearns | 2010-06-06 23:23:03 | Re: PITR Recovery Question |