Re: [PERFORM] fine tuning for logging server

2005-03-30 Thread Florin Andrei
On Wed, 2005-03-30 at 20:11 -0600, John Arbash Meinel wrote: > Florin Andrei wrote: > > > >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 tha

Re: [PERFORM] fine tuning for logging server

2005-03-30 Thread Florin Andrei
it is. I cannot change that. -- Florin Andrei http://florin.myip.org/ ---(end of broadcast)--- TIP 7: don't forget to increase your free space map settings

Re: [PERFORM] fine tuning for logging server

2005-03-30 Thread Florin Andrei
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 > othe

[PERFORM] fine tuning for logging server

2005-03-30 Thread Florin Andrei
uch a situation? -- Florin Andrei http://florin.myip.org/ ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through