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 0C7D553435 for ; Thu, 31 Mar 2005 02:50:20 +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 29818-06 for ; Thu, 31 Mar 2005 01:50:11 +0000 (GMT) Received: from rwcrmhc12.comcast.net (rwcrmhc12.comcast.net [216.148.227.85]) by svr1.postgresql.org (Postfix) with ESMTP id 1070852A6A for ; Thu, 31 Mar 2005 02:50:09 +0100 (BST) Received: from andrei.myip.org ([24.6.189.81]) by comcast.net (rwcrmhc12) with ESMTP id <2005033101501201400dtnuae>; Thu, 31 Mar 2005 01:50:13 +0000 Received: from localhost (weiqi.home.local [127.0.0.1]) by andrei.myip.org (Postfix) with ESMTP id F0C34B4067 for ; Wed, 30 Mar 2005 17:50:11 -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-02 for ; Wed, 30 Mar 2005 17:50:10 -0800 (PST) Received: from [192.168.2.6] (unknown [192.168.2.6]) by andrei.myip.org (Postfix) with ESMTP id 21C34B4063 for ; Wed, 30 Mar 2005 17:50:10 -0800 (PST) Subject: fine tuning for logging server From: Florin Andrei Reply-To: pgsql-performance@postgresql.org To: pgsql-performance@postgresql.org Content-Type: text/plain Date: Wed, 30 Mar 2005 17:50:09 -0800 Message-Id: <1112233809.10313.31.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 tagged_above=0 required=5 tests= X-Spam-Level: X-Archive-Number: 200503/666 X-Sequence-Number: 11371 Hardware: relatively modern Intel CPU, OS and database each on its own IDE hard-drive (separate IDE cables). Enough memory, i think, but i can't add too much (not beyond 1GB). Software: Linux-2.6, pgsql-8.0.1 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. Objective: Make the DB as fast as possible. Of course i'd like the SELECTs to be fast, but the INSERTs take precedence. It's gotta be able to swallow as many messages per second as possible given the hardware. Question: What are the pgsql parameters that need to be tweaked? What are the guidelines for such a situation? -- Florin Andrei http://florin.myip.org/