Re: [PERFORM] Postgres processes have a burst of CPU usage

2007-01-24 Thread Richard Huxton
Subramaniam Aiylam wrote: Now, there is one particular update that I make from one of the client machines - this involves a reasonably large object graph (from the Java point of view). It deletes a bunch of rows (around 20 rows in all) in 4-5 tables and inserts another bunch into the same table

[PERFORM] Postgres processes have a burst of CPU usage

2007-01-23 Thread Subramaniam Aiylam
Hello all, I have a setup in which four client machines access a Postgres database (8.1.1) (on a Linux box). So, there are connections from each machine to the database; hence, the Linux box has about 2 postgres processes associated with each machine. I am using the JDBC driver (postgresql-8.