Re: [GENERAL] postgresql performace degrading after a while

2006-01-30 Thread Rick Gigger
On Jan 30, 2006, at 12:28 AM, Ron Marom wrote: First of all thanks for you quick and efficient response. Indeed I forgot to mention that I AM vacuuming the database using a daemon every few hours; however this seems not to be the issue this time, as when the CPU consumptions went up I tried to

Re: [GENERAL] postgresql performace degrading after a while

2006-01-30 Thread Tom Lane
"Ron Marom" <[EMAIL PROTECTED]> writes: > Indeed I forgot to mention that I AM vacuuming the database using a > daemon every few hours; however this seems not to be the issue this > time, as when the CPU consumptions went up I tried to vacuum manually > and this seemed to take no affect. This is n

Re: [GENERAL] postgresql performace degrading after a while

2006-01-30 Thread Martijn van Oosterhout
On Mon, Jan 30, 2006 at 09:28:14AM +0200, Ron Marom wrote: > Indeed I forgot to mention that I AM vacuuming the database using a > daemon every few hours; however this seems not to be the issue this > time, as when the CPU consumptions went up I tried to vacuum manually > and this seemed to take no

Re: [GENERAL] postgresql performace degrading after a while

2006-01-29 Thread Ron Marom
performace degrading after a while On Mon, Jan 30, 2006 at 09:02:24AM +0200, Ron Marom wrote: > I seem to have a problem with postgresql 7.4.2 running on Red Hat > Enterprise Linux ES3. If you can't upgrade to 8.0 or 8.1 then at least consider using the latest version in the 7.4 bra

Re: [GENERAL] postgresql performace degrading after a while

2006-01-29 Thread Michael Fuhr
On Mon, Jan 30, 2006 at 09:02:24AM +0200, Ron Marom wrote: > I seem to have a problem with postgresql 7.4.2 running on Red Hat > Enterprise Linux ES3. If you can't upgrade to 8.0 or 8.1 then at least consider using the latest version in the 7.4 branch (7.4.11). You're missing almost two years of