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
[-- Attachment #1 --] Axel Rau wrote: > Hi, > > I'm starting migration of my PostgreSQL tablespaces to gjournaled fs on > 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 journaled file system doesn't do much. If you really want it, it won't hurt you. Journal size needs to be 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 your array does 100 MB/s, you need a 2000 MB journal. This calculation is for default gjournal settings. You could put the journal on another drive or array for best performance. (Of course, you could skip gjournal and put the WAL on the other drive). [-- Attachment #2 --] -----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-----
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?g7jmi6$dsa$1>