Re: [PERFORM] Memory usage of writer process

2009-08-14 Thread Alex Neth
This is postgres 8.4 BTW. It says 2.9Gb of RESIDENT memory, that also seems to be shared. Is this the writer sharing the records it wrote in a shared buffer? PID USER PR NI VIRT RES SHR S %CPU %MEMTIME+ COMMAND 11088 postgres 13 -2 3217m 3.0g 3.0g S0 39.5 0:14.23 postgres

Re: [PERFORM] Memory usage of writer process

2009-08-13 Thread Scott Carey
On 8/12/09 9:44 PM, "Alex" wrote: > The writer process seems to be using inordinate amounts of memory: > > PID USER PR NI VIRT RES SHR S %CPU %MEMTIME+ > COMMAND > 11088 postgres 13 -2 3217m 2.9g 2.9g S0 38.7 0:10.46 postgres: > writer process > 20190 postgres 13 -2 3

Re: [PERFORM] Memory usage of writer process

2009-08-13 Thread Alvaro Herrera
Alex wrote: > The writer process seems to be using inordinate amounts of memory: > > PID USER PR NI VIRT RES SHR S %CPU %MEMTIME+ > COMMAND > 11088 postgres 13 -2 3217m 2.9g 2.9g S0 38.7 0:10.46 postgres: > writer process > 20190 postgres 13 -2 3219m 71m 68m S0 0.9

[PERFORM] Memory usage of writer process

2009-08-13 Thread Alex
The writer process seems to be using inordinate amounts of memory: PID USER PR NI VIRT RES SHR S %CPU %MEMTIME+ COMMAND 11088 postgres 13 -2 3217m 2.9g 2.9g S0 38.7 0:10.46 postgres: writer process 20190 postgres 13 -2 3219m 71m 68m S0 0.9 0:52.48 postgres: cribq