Re: OpenBSD and PostgreSQL performance

2006-03-22 Thread Melameth, Daniel D.
Jim Razmus wrote: > * Steve Shockley <[EMAIL PROTECTED]> [060322 21:35]: > > I've currently got a server running syslog-ng (1.6.9) with > > PostgreSQL (8.1.1) on a 3.9 snapshot from March 1. The setup has > > been working well for a while, but I've recently been told to have > > it accept syslog f

Re: OpenBSD and PostgreSQL performance

2006-03-22 Thread Darrin Chandler
Steve Shockley wrote: I've currently got a server running syslog-ng (1.6.9) with PostgreSQL (8.1.1) on a 3.9 snapshot from March 1. The setup has been working well for a while, but I've recently been told to have it accept syslog for a couple of anti-spam appliance devices, and they generate

Re: OpenBSD and PostgreSQL performance

2006-03-22 Thread Lars Hansson
On Thursday 23 March 2006 10:26, Steve Shockley wrote: > Any query which needs to iterate the whole database will > take 10-15 minutes after a day or so, and that's no good for a web > front-end. The first order of business should be to get rid of these kind of queries. --- Lars Hansson

Re: OpenBSD and PostgreSQL performance

2006-03-22 Thread Jim Razmus
* Steve Shockley <[EMAIL PROTECTED]> [060322 21:35]: > I've currently got a server running syslog-ng (1.6.9) with PostgreSQL > (8.1.1) on a 3.9 snapshot from March 1. The setup has been working well > for a while, but I've recently been told to have it accept syslog for a > couple of anti-spam

Re: OpenBSD and PostgreSQL performance

2006-03-22 Thread Aaron Glenn
On 3/22/06, Steve Shockley <[EMAIL PROTECTED]> wrote: > I've currently got a server running syslog-ng (1.6.9) with PostgreSQL > (8.1.1) on a 3.9 snapshot from March 1. The setup has been working well > for a while, but I've recently been told to have it accept syslog for a > couple of anti-spam ap

OpenBSD and PostgreSQL performance

2006-03-22 Thread Steve Shockley
I've currently got a server running syslog-ng (1.6.9) with PostgreSQL (8.1.1) on a 3.9 snapshot from March 1. The setup has been working well for a while, but I've recently been told to have it accept syslog for a couple of anti-spam appliance devices, and they generate between 1-2 million sys