Skip site navigation (1) Skip section navigation (2)

fine tuning for logging server

From: Florin Andrei <florin(at)andrei(dot)myip(dot)org>
To: pgsql-performance(at)postgresql(dot)org
Subject: fine tuning for logging server
Date: 2005-03-31 01:50:09
Message-ID: 1112233809.10313.31.camel@stantz.corp.sgi.com (view raw or flat)
Thread:
Lists: pgsql-performance
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/


Responses

pgsql-performance by date

Next:From: John Arbash MeinelDate: 2005-03-31 01:59:30
Subject: Re: fine tuning for logging server
Previous:From: Mohan, RossDate: 2005-03-30 23:09:59
Subject: Re: Reading recommendations

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group