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 86435533CA for ; Thu, 31 Mar 2005 03:03:00 +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 34740-08 for ; Thu, 31 Mar 2005 02:02:55 +0000 (GMT) Received: from sccrmhc14.comcast.net (sccrmhc14.comcast.net [204.127.202.59]) by svr1.postgresql.org (Postfix) with ESMTP id 3133252A5D for ; Thu, 31 Mar 2005 03:02:54 +0100 (BST) Received: from andrei.myip.org ([24.6.189.81]) by comcast.net (sccrmhc14) with ESMTP id <2005033102025701400dln3ce>; Thu, 31 Mar 2005 02:02:57 +0000 Received: from localhost (weiqi.home.local [127.0.0.1]) by andrei.myip.org (Postfix) with ESMTP id 4236AB4067 for ; Wed, 30 Mar 2005 18:02:56 -0800 (PST) Received: from andrei.myip.org ([127.0.0.1]) by localhost (weiqi.home.local [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 00315-08 for ; Wed, 30 Mar 2005 18:02:55 -0800 (PST) Received: from [192.168.2.6] (unknown [192.168.2.6]) by andrei.myip.org (Postfix) with ESMTP id EB9B7B4063 for ; Wed, 30 Mar 2005 18:02:54 -0800 (PST) Subject: Re: fine tuning for logging server From: Florin Andrei Reply-To: pgsql-performance@postgresql.org To: pgsql-performance@postgresql.org In-Reply-To: <1112233809.10313.31.camel@stantz.corp.sgi.com> References: <1112233809.10313.31.camel@stantz.corp.sgi.com> Content-Type: text/plain Date: Wed, 30 Mar 2005 18:02:54 -0800 Message-Id: <1112234574.12159.1.camel@stantz.corp.sgi.com> Mime-Version: 1.0 X-Mailer: Evolution 2.0.4 (2.0.4-2) Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at andrei.myip.org X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.025 tagged_above=0 required=5 tests=AWL, FORGED_RCVD_HELO X-Spam-Level: X-Archive-Number: 200503/668 X-Sequence-Number: 11373 On Wed, 2005-03-30 at 17:50 -0800, Florin Andrei wrote: > Function: Essentially a logging server. There are two applications (like > syslog) on the same box that are logging to pgsql, each one to its own > database. There are a few tables in one DB, and exactly one table in the > other. > Most of the time, the apps are just doing mindless INSERTs to the DB. > Every now and then, an admin performs some SELECTs via a PHP interface. For performance reasons, i was thinking to keep the tables append-only, and simply rotate them out every so often (daily?) and delete those tables that are too old. Is that a good idea? -- Florin Andrei http://florin.myip.org/