Re: [GENERAL] CPU load high

2007-08-23 Thread Patrick Lindeman
even show more information which might come in handy. Good Luck, - Patrick Lindeman > Hello. > > I have a web-server with php 5.2 connected to postgres 8.0 backend. Most > of the queries the users are doing are SELECTs (100-150 in a second for > 100 concurrent users), with a 5-10 IN

Re: [GENERAL] could not open file "pg_clog/0BFF"

2007-08-22 Thread Patrick Lindeman
Thanks for your replies so far, it seems like the problem has been solved, for now! > On 8/22/07, Patrick Lindeman <[EMAIL PROTECTED]> wrote: >> Hi, >> >> While checking the logfiles of our postgresql server I noticed the error >> mentioned in the subject: >>

[GENERAL] could not open file "pg_clog/0BFF"

2007-08-22 Thread Patrick Lindeman
ot; and is it more than just coincidence that since that moment the vacuum stopped running? Is there anything we can do to prevent this in future use? Besides we are using PostgreSQL 8.1.3. Any help would be appreciated. Regards, Patrick Lindeman ---(end of broadca