Hi Michiel (and others), Onpreface, sorry for my dummy skills on postgresql
Vacuumdb: Nope, read the manual, can I use it with the database running, should I use it to clean garbage and/or analyze the data. Slow queries: Is there a easy way to get the slow ones (CPU consuming ones) Version postgresql: Requirement of app developer MMBase: 1.5 (also Requirement of app developer) Regards, Laurens -----Original Message----- From: Michiel Meeuwissen [mailto:[EMAIL PROTECTED] Sent: Monday, September 06, 2004 1:42 PM To: [EMAIL PROTECTED] Subject: Re: CPU usuage Postgresql Laurens Wagemakers <[EMAIL PROTECTED]> wrote: > Hello all, > > A MMBase installation on Postgresql 7.2.1 which is running at a customer > site has some problems with the CPU usage of the Postgresql servers. > They (7-8 servers) are eating 80-90% of all the CPU (on a Solaris 9 system > with 2 * 1Ghz Sparc processor) > > It is not sure when the problem occurs probably at mutating the site. > > Does anyone have any experience with this CPU problem Do you run vacuumdb regularly? Did you explore which kind of queries are slow? Why don't you use a more recent version of postgresql? Which version of MMBase? Michiel -- Michiel Meeuwissen mihxil' Mediacentrum 140 H'sum [] () +31 (0)35 6772979 nl_NL eo_XX en_US
