Received: from maia.hub.org (maia-3.hub.org [200.46.204.243]) by mail.postgresql.org (Postfix) with ESMTP id 18703133655C for ; Sat, 9 Oct 2010 18:29:01 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.243]) (amavisd-maia, port 10024) with ESMTP id 80433-06 for ; Sat, 9 Oct 2010 21:28:54 +0000 (UTC) X-Greylist: delayed 00:43:02.484827 by SQLgrey-1.7.6 Received: from ka.mail.enyo.de (ka.mail.enyo.de [87.106.162.201]) by mail.postgresql.org (Postfix) with ESMTP id C269E1337B80 for ; Sat, 9 Oct 2010 18:28:53 -0300 (ADT) Received: from [172.17.135.4] (helo=deneb.enyo.de) by ka.mail.enyo.de with esmtps (TLS1.0:RSA_AES_256_CBC_SHA1:32) id 1P4gId-0006sl-QR; Sat, 09 Oct 2010 22:45:47 +0200 Received: from fw by deneb.enyo.de with local (Exim 4.72) (envelope-from ) id 1P4gId-0002SC-IW; Sat, 09 Oct 2010 22:45:47 +0200 From: Florian Weimer To: Greg Smith Cc: Aaron Turner , pgsql-performance Subject: Re: large dataset with write vs read clients References: <4CAE3FDB.1040909@2ndquadrant.com> Date: Sat, 09 Oct 2010 22:45:47 +0200 In-Reply-To: <4CAE3FDB.1040909@2ndquadrant.com> (Greg Smith's message of "Thu, 07 Oct 2010 17:47:07 -0400") Message-ID: <87ocb3yu10.fsf@mid.deneb.enyo.de> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-1.91 tagged_above=-10 required=5 tests=BAYES_00=-1.9, T_RP_MATCHES_RCVD=-0.01 X-Spam-Level: X-Archive-Number: 201010/75 X-Sequence-Number: 40494 * Greg Smith: > Given the size of your database, I'd advise you consider a migration > to a new version ASAP. 8.4 is a nice stable release at this point, > that's the one to consider moving to. It also offers asynchronous commits, which might be a good tradeoff here (especially if the data gathered is not used for billing purposes 8-).