pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Andrew Hammond <ahammond@ca.afilias.info>
To: Postgresql Performance <pgsql-performance@postgresql.org>
Cc: Rod Taylor <pg@rbt.ca>
Subject: Re: NAS, SAN or any alternate solution ?
Date: Wed, 22 Sep 2004 16:34:47 -0400
Message-ID: <4151E1E7.2000009@ca.afilias.info> (raw)
In-Reply-To: <1090344321.7056.105.camel@jester>
References: <OF87F30D92.9973FC60-ONC1256ED7.0029C226-C1256ED7.002B6957@beauchamp.loxane.fr>
	<1090344321.7056.105.camel@jester>

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Rod Taylor wrote:
| I've used both a NetApp and Hitachi based SANs with PostgreSQL. Both
| work as well as expected, but do require some tweeking as they normally
| are not optimized for the datablock size that PostgreSQL likes to deal
| with (8k by default) -- this can make as much as a 50% difference in
| performance levels.

I'm looking for documentation about the datablock size you mentioned above.

My goal is to tune the disk / filesystem on our prototype system. It's
an EMC disk array, so sectors on disk are 512 bytes of usable space.
We've decided to go with RAID 10 since the goal is to maximize
performance. Currently the raid element size is set at 16 sectors which
is 8192 bytes of payload. I've got a sysadmin working on getting XFS
going with 8192 byte blocks. My next task will be to calculate the
amount of space used by XFS for headers etc. to find out how much of
those 8192 bytes can be used for the postgres payload. Then configure
postgres to use datablocks that size. So I'm looking for details on how
to manipulate the size of the datablock.

I'm also not entirely sure how to make the datablocks line up with the
filesystem blocks. Any suggestions on this would be greatly appreciated.

- --
Andrew Hammond    416-673-4138    ahammond@ca.afilias.info
Database Administrator, Afilias Canada Corp.
CB83 2838 4B67 D40F D086 3568 81FC E7E5 27AF 4A9A
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.5 (GNU/Linux)

iD8DBQFBUeHmgfzn5SevSpoRAu2sAJ4nHHup5lhp4+RcgBPGoJpUFoE1SQCgyvW1
ixyAvqb7ZkB+IIdGb36mpxI=
=uDLW
-----END PGP SIGNATURE-----



view thread (9+ messages)  latest in thread

Message-ID: <4151E1E7.2000009@ca.afilias.info>
Permalink:  ../4151E1E7.2000009@ca.afilias.info/
Also on:    postgresql.org/message-id/4151E1E7.2000009@ca.afilias.info

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-performance@postgresql.org
  Cc: ahammond@ca.afilias.info, pg@rbt.ca
  Subject: Re: NAS, SAN or any alternate solution ?
  In-Reply-To: <4151E1E7.2000009@ca.afilias.info>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

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