pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Florin Andrei <florin@andrei.myip.org>
To: pgsql-performance@postgresql.org
Subject: fine tuning for logging server
Date: Wed, 30 Mar 2005 17:50:09 -0800
Message-ID: <1112233809.10313.31.camel@stantz.corp.sgi.com> (raw)

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/




view thread (10+ messages)  latest in thread

Message-ID: <1112233809.10313.31.camel@stantz.corp.sgi.com>
Permalink:  ../1112233809.10313.31.camel@stantz.corp.sgi.com/
Also on:    postgresql.org/message-id/1112233809.10313.31.camel@stantz.corp.sgi.com

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-performance@postgresql.org
  Cc: florin@andrei.myip.org
  Subject: Re: fine tuning for logging server
  In-Reply-To: <1112233809.10313.31.camel@stantz.corp.sgi.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox