suggested block size for a frequently updated postgresql?

Dryice Liu <[email protected]>
Newsgroups gmane.os.freebsd.devel.database
Message-ID <[email protected]>
I'm planning on setting up a postgresql server, the database data
files are on their own slice so I can tune the file system for pgsql.

The database is pretty large. On my test server, some data files get
larger than 1G and is splitted by pgsql. Also the database will be
updated frequently.

I'm planning on setting the slice with a bigger block size/fragment
size but not sure if that's a good idea. I know the default on FreeBSD
is 16K/2K, I'm planning on something like 1M/128K.

The most concern is how the database files get updated? I heard that
most database do update/delete by appending a mark and new record at
the end of the data file but can't find any evidence for that. If
that's true, then the thing looks good. But if the database update the
data file by changing the original file block, setting a bigger block
size may bring extra effort for the drive, especially when it's a
RAID5 and a checksum build is required.

Can someone shine some light on this? Thanks!

-- 
Dryice @ http://dryice.3322.org

Please avoid sending me Word or PowerPoint attachments.
See http://www.gnu.org/philosophy/sylvester-response.html
signature.asc (application/pgp-signature, 186 B)
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.2 (FreeBSD)

iD8DBQBDdGO3a1t4qHe2eHQRAkszAJ0bclnu1HRXwVrXmeeFulgjmMK99gCeK3Yl
X2zpG6s0vLUKfrbLX5LjPEM=
=UVJp
-----END PGP SIGNATURE-----
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.