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 43E0A535D0 for ; Wed, 27 Apr 2005 12:26:48 -0300 (ADT) 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 90410-05 for ; Wed, 27 Apr 2005 15:26:38 +0000 (GMT) Received: from tht.net (vista.tht.net [216.126.88.2]) by svr1.postgresql.org (Postfix) with ESMTP id 44289535D3 for ; Wed, 27 Apr 2005 12:26:35 -0300 (ADT) Received: from 216-154-15-113.dsl.look.ca (216-154-15-113.dsl.look.ca [216.154.15.113]) by tht.net (Postfix) with ESMTP id 55C5C76A28; Wed, 27 Apr 2005 11:26:36 -0400 (EDT) Subject: Re: Final decision From: Rod Taylor To: Joel Fradkin Cc: PostgreSQL Perform In-Reply-To: <000001c54b3a$054d3720$797ba8c0@jfradkin> References: <000001c54b3a$054d3720$797ba8c0@jfradkin> Content-Type: text/plain Date: Wed, 27 Apr 2005 11:23:43 -0400 Message-Id: <1114615423.77587.175.camel@home> Mime-Version: 1.0 X-Mailer: Evolution 2.2.2 FreeBSD GNOME Team Port Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests= X-Spam-Level: X-Archive-Number: 200504/726 X-Sequence-Number: 12123 > > I did have a question if any folks are using two servers one for > reporting and one for data entry what system should be the beefier? Yeah. We started putting up slaves for reporting purposes and application specific areas using Slony replicating partial data sets to various locations -- some for reporting. If your reports have a long runtime and don't require transactional safety for writes (daily summary written or results aren't recorded in the DB at all) this is probably something to consider. I understand that PGAdmin makes Slony fairly painless to setup, but it can be time consuming to get going and Slony can add new complications depending on the data size and what you're doing with it -- but they're working hard to reduce the impact of those complications. > I have a 2proc machine I will be using and I can either put Sears off > by themselves on this machine or split up functionality and have one > for reporting and one for inserts and updates; so not sure which > machine would be best for which spot (reminder the more robust is a > 4proc with 8 gigs and 2 proc is 4 gigs, both dells). > > > > Thank you for any ideas in this arena. > > > > Joel Fradkin > > > > > > > > > --