From owner-freebsd-database@FreeBSD.ORG Sat Aug 9 10:08:25 2008 Return-Path: Delivered-To: freebsd-database@freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2001:4f8:fff6::34]) by hub.freebsd.org (Postfix) with ESMTP id 9E22B106564A for ; Sat, 9 Aug 2008 10:08:25 +0000 (UTC) (envelope-from freebsd-database@m.gmane.org) Received: from ciao.gmane.org (main.gmane.org [80.91.229.2]) by mx1.freebsd.org (Postfix) with ESMTP id 25F4A8FC0C for ; Sat, 9 Aug 2008 10:08:24 +0000 (UTC) (envelope-from freebsd-database@m.gmane.org) Received: from list by ciao.gmane.org with local (Exim 4.43) id 1KRkMx-00018I-48 for freebsd-database@freebsd.org; Sat, 09 Aug 2008 09:04:15 +0000 Received: from 89-172-33-199.adsl.net.t-com.hr ([89.172.33.199]) by main.gmane.org with esmtp (Gmexim 0.1 (Debian)) id 1AlnuQ-0007hv-00 for ; Sat, 09 Aug 2008 09:04:15 +0000 Received: from ivoras by 89-172-33-199.adsl.net.t-com.hr with local (Gmexim 0.1 (Debian)) id 1AlnuQ-0007hv-00 for ; Sat, 09 Aug 2008 09:04:15 +0000 X-Injected-Via-Gmane: http://gmane.org/ To: freebsd-database@freebsd.org From: Ivan Voras Date: Sat, 09 Aug 2008 11:03:55 +0200 Lines: 48 Message-ID: References: <8A4CC87D-8B69-4120-BB89-F794E4FFD871@Chaos1.DE> Mime-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha1; protocol="application/pgp-signature"; boundary="------------enigDC8A8B96BB2B2F5AA316C4D7" X-Complaints-To: usenet@ger.gmane.org X-Gmane-NNTP-Posting-Host: 89-172-33-199.adsl.net.t-com.hr User-Agent: Thunderbird 2.0.0.16 (Windows/20080708) In-Reply-To: <8A4CC87D-8B69-4120-BB89-F794E4FFD871@Chaos1.DE> X-Enigmail-Version: 0.95.6 Sender: news Subject: Re: PostgreSQL 3.3 on gjournaled fs X-BeenThere: freebsd-database@freebsd.org X-Mailman-Version: 2.1.5 Precedence: list List-Id: Database use and development under FreeBSD List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Sat, 09 Aug 2008 10:08:25 -0000 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--