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: (view raw, whole thread or download thread mbox)
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

In response to


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-2017 The PostgreSQL Global Development Group