Re: Postgres is eating my CPU

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: james(at)unifiedmind(dot)com (James Thornton)
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: Postgres is eating my CPU
Date: 2001-09-04 15:46:37
Message-ID: 26650.999618397@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

james(at)unifiedmind(dot)com (James Thornton) writes:
> As you can see from the ps output, there are several INSERT statements
> -- these return after restarting Postgres and even rebooting the
> system.

Postgres backends don't just appear out of nowhere. Somewhere you have
a client app that is connecting to the database and issuing those INSERT
commands. Without knowing what that app is or exactly what commands it's
issuing, it's impossible to say what's going on.

regards, tom lane

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Joe Conway 2001-09-04 15:46:44 Re: Bytea/Base64 encoders for libpq - interested?
Previous Message Karel Zak 2001-09-04 15:43:18 Re: [PATCHES] to_char and Roman Numeral (RN) bug