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

Re: fine tuning for logging server

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


In response to

Responses

pgsql-performance by date

Next:From: John Arbash MeinelDate: 2005-03-31 02:11:59
Subject: Re: fine tuning for logging server
Previous:From: John Arbash MeinelDate: 2005-03-31 01:59:30
Subject: Re: fine tuning for logging server

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