Re: [SQL] Postgres process resident size does not drop after killing statement

2009-04-15 Thread Tom Lane
Bryce Nesbitt writes: > Every so often our production Postgres 8.3 system will get statement > that runs for a few hours, or a few days, or more, and needs to be > killed dead. We kill it with pg_cancel_backend(), and cpu usage of the > process immediately drops, and the process starts serving ot

[SQL] Postgres process resident size does not drop after killing statement

2009-04-14 Thread Bryce Nesbitt
Every so often our production Postgres 8.3 system will get statement that runs for a few hours, or a few days, or more, and needs to be killed dead. We kill it with pg_cancel_backend(), and cpu usage of the process immediately drops, and the process starts serving other statements. But the curio