From owner-freebsd-database@FreeBSD.ORG Fri Aug 8 23:58:29 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 17D5F1065686 for ; Fri, 8 Aug 2008 23:58:29 +0000 (UTC) (envelope-from Axel.Rau@chaos1.de) Received: from mail1.chaos1.de (Mail1.Chaos1.DE [213.160.12.53]) by mx1.freebsd.org (Postfix) with ESMTP id CD6A28FC14 for ; Fri, 8 Aug 2008 23:58:28 +0000 (UTC) (envelope-from Axel.Rau@chaos1.de) Received: from mail3.chaos1.de ([213.160.12.56]) by mail1.chaos1.de with esmtp (Exim 4.44) id 1KRbaf-00032m-4v for freebsd-database@freebsd.org; Sat, 09 Aug 2008 01:41:49 +0200 Received: from 192.168.220.106 (HELO claudius6.in.chaos1.de) by mail3.chaos1.de with esmtp id 1218238909-848-1394; Fri, 8 Aug 2008 23:41:49 +0000 Message-Id: <8A4CC87D-8B69-4120-BB89-F794E4FFD871@Chaos1.DE> From: Axel Rau To: freebsd-database@freebsd.org Content-Type: text/plain; format=flowed; delsp=yes Mime-Version: 1.0 (Apple Message framework v926) Date: Sat, 9 Aug 2008 01:41:48 +0200 X-Mailer: Apple Mail (2.926) Subject: 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: Fri, 08 Aug 2008 23:58:29 -0000 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? Axel --- 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-- From owner-freebsd-database@FreeBSD.ORG Sat Aug 9 14:01:53 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 B1D501065679 for ; Sat, 9 Aug 2008 14:01:53 +0000 (UTC) (envelope-from Axel.Rau@chaos1.de) Received: from mail1.chaos1.de (Mail1.Chaos1.DE [213.160.12.53]) by mx1.freebsd.org (Postfix) with ESMTP id 6F61F8FC2B for ; Sat, 9 Aug 2008 14:01:53 +0000 (UTC) (envelope-from Axel.Rau@chaos1.de) Received: from mail3.chaos1.de ([213.160.12.56]) by mail1.chaos1.de with esmtp (Exim 4.44) id 1KRp0x-00023v-4z; Sat, 09 Aug 2008 16:01:51 +0200 Received: from 192.168.220.106 (HELO claudius6.in.chaos1.de) by mail3.chaos1.de with esmtp id 1218290509-74140-11; Sat, 9 Aug 2008 14:01:49 +0000 Message-Id: <3B2D25A1-5A0D-4163-A248-E709ADD54CC5@Chaos1.DE> From: Axel Rau To: Ivan Voras In-Reply-To: Content-Type: text/plain; format=flowed; delsp=yes Mime-Version: 1.0 (Apple Message framework v926) Date: Sat, 9 Aug 2008 16:01:40 +0200 References: <8A4CC87D-8B69-4120-BB89-F794E4FFD871@Chaos1.DE> X-Mailer: Apple Mail (2.926) Cc: freebsd-database@freebsd.org 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 14:01:53 -0000 Am 09.08.2008 um 11:03 schrieb Ivan Voras: > 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. I want to prevent from fsck on large filesystems after outage. > > > 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. This is usefull info. > > > 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). I have the latter, but intent to put this on gjournal too. Axel ---