On Thu, 30 Dec 2004 09:27:19 +0100
Berteun Damman <berteun@gmail.com> wrote:
> Hello,
> 
> Currently I'm runing PostgreSQL 7.4.6 on NetBSD 2.0 (release, but with
> own kernel), and I'm able to start PostgreSQL, and after that it
> performs normally for a while, but after it hasn't done anything for a
> while (after 12 hours idling or so), it just starts to consume all CPU
> time,

This is really a PostgreSQL question, not a NetBSD one.  Check out the
mailing lists at http://www.PostgreSQL.org/ and ask on their help
channel.  A few tips for when you do.

 - Try to explain in as much detail as possible what sort of work you
are doing with the database.
 - Show the output of "ps -axw | grep postm" so that they know exactly
which process is using all the CPU.
 - Make sure that you describe your operating system, version and
hardware.

Note that it is possible that you will eventually be sent back here
depending on what they find out but they need to be your first stop.

Good luck.

-- 
D'Arcy J.M. Cain <darcy@NetBSD.org>
http://www.NetBSD.org/