Date: Sat, 09 Aug 2008 11:03:55 +0200 From: Ivan Voras <ivoras@freebsd.org> To: freebsd-database@freebsd.org Subject: Re: PostgreSQL 3.3 on gjournaled fs Message-ID: <g7jmi6$dsa$1@ger.gmane.org> In-Reply-To: <8A4CC87D-8B69-4120-BB89-F794E4FFD871@Chaos1.DE> References: <8A4CC87D-8B69-4120-BB89-F794E4FFD871@Chaos1.DE>
next in thread | previous in thread | raw e-mail | index | archive | help
This is an OpenPGP/MIME signed message (RFC 2440 and 3156) --------------enigDC8A8B96BB2B2F5AA316C4D7 Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: quoted-printable Axel Rau wrote: > Hi, >=20 > I'm starting migration of my PostgreSQL tablespaces to gjournaled fs on= =20 > 7-stable. > Dedicated box is Opteron with Areca. > Any experiences or hints? > 4GB journal provider? The question is - why do you need gjournal? PostgreSQL (and other decent = databases) does its own journaling (search for WAL), so using it on a=20 journaled file system doesn't do much. If you really want it, it won't hurt you. Journal size needs to be=20 scaled based on your load. If you have constant writes you need a larger = journal. You need it to hold 20*(write_rate in MB/s) megabytes. E.g. if=20 your array does 100 MB/s, you need a 2000 MB journal. This calculation=20 is for default gjournal settings. You could put the journal on another drive or array for best=20 performance. (Of course, you could skip gjournal and put the WAL on the=20 other drive). --------------enigDC8A8B96BB2B2F5AA316C4D7 Content-Type: application/pgp-signature; name="signature.asc" Content-Description: OpenPGP digital signature Content-Disposition: attachment; filename="signature.asc" -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.2.5 (MingW32) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iD8DBQFInV2BldnAQVacBcgRAp8aAJ9iP3sTts7b1+S6Ol35OfQhy8YqAQCfd3L5 kPShxQJH0eZxsYXZR+jHNiM= =nfFn -----END PGP SIGNATURE----- --------------enigDC8A8B96BB2B2F5AA316C4D7--
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?g7jmi6$dsa$1>