[GENERAL] Pgsql taking a *lot* of CPU time (unkillable).

2005-01-15 Thread Berteun Damman
Hello, I'm currently running PostgreSQL 7.4.6 under NetBSD 2.0 (Release), but with a custom kernel. I can start it, and it performs normally, i.e. I can access my databases and such. Now I'm primarily using it with the GNUCash PostgreSQL backend. After I've finished using it, and leaving it to it

Re: [GENERAL] Pgsql taking a *lot* of CPU time (unkillable).

2005-01-15 Thread Berteun Damman
On Sat, 15 Jan 2005 13:15:36 -0500, Tom Lane <[EMAIL PROTECTED]> wrote: > Would you attach to the process with a debugger and get a stack trace? > > $ gdb /usr/pkg/bin/postgres PID-of-process > gdb> bt > gdb> q > > Probably should repeat this a few times to get a clear sen

Re: [GENERAL] Pgsql taking a *lot* of CPU time (unkillable).

2005-01-15 Thread Berteun Damman
On Sat, 15 Jan 2005 16:25:34 -0500, Tom Lane <[EMAIL PROTECTED]> wrote: > You don't need to reproduce the bug from scratch each time. What I > meant was, once it seems to be spinning, repeatedly attach to it with > gdb and see if you can get a backtrace. If not, just quit gdb and try > again. Oh