X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 83A49329F69 for ; Mon, 4 Oct 2004 20:00:34 +0100 (BST) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 18946-09 for ; Mon, 4 Oct 2004 19:00:26 +0000 (GMT) Received: from davinci.ethosmedia.com (server226.ethosmedia.com [209.128.84.226]) by svr1.postgresql.org (Postfix) with ESMTP id 53336329E91 for ; Mon, 4 Oct 2004 20:00:26 +0100 (BST) Received: from [64.81.245.111] (account josh@agliodbs.com HELO temoku.sf.agliodbs.com) by davinci.ethosmedia.com (CommuniGate Pro SMTP 4.1.8) with ESMTP id 6456684; Mon, 04 Oct 2004 12:01:48 -0700 From: Josh Berkus Reply-To: josh@agliodbs.com Organization: Aglio Database Solutions To: Steve Atkins Subject: Re: Performance suggestions for an update-mostly database? Date: Mon, 4 Oct 2004 12:02:03 -0700 User-Agent: KMail/1.6.2 Cc: pgsql-performance@postgresql.org References: <20041004174019.GA25671@gp.word-to-the-wise.com> <200410041038.14571.josh@agliodbs.com> <20041004180036.GA26390@gp.word-to-the-wise.com> In-Reply-To: <20041004180036.GA26390@gp.word-to-the-wise.com> MIME-Version: 1.0 Content-Disposition: inline Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit Message-Id: <200410041202.03548.josh@agliodbs.com> X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests= X-Spam-Level: X-Archive-Number: 200410/33 X-Sequence-Number: 8509 Steve, > In some ways something like Berkeley DB might be a better match to the > frontend, but I'm comfortable with PostgreSQL and prefer to have the > power of SQL commandline for when I need it. Well, if data corruption is not a concern, you can always turn off checkpointing. This will save you a fair amount of overhead. You could also look at telegraphCQ. It's not prodcucton yet, but their idea of "streams" as data sources really seems to fit with what you're talking about. -- --Josh Josh Berkus Aglio Database Solutions San Francisco