Re: High RAM usage on postgres

Am 17.03.2013 09:31, schrieb Scott Marlowe:
> On Thu, Mar 14, 2013 at 12:55 PM, prashantmalik
> <prashantmalikk(at)gmail(dot)com> wrote:
>>
>> *Query :* "SELECT * FROM customer"
>> -----------------------------------------------------------------------------------------------------------------------------------------------------------
>> top
>>
>> top - 00:14:38 up 44 days, 12:06, 2 users, load average: 3.57, 1.34, 0.69
>> Tasks: 243 total, 3 running, 240 sleeping, 0 stopped, 0 zombie
>> Cpu(s): 6.5%us, 0.6%sy, 0.0%ni, 92.5%id, 0.4%wa, 0.0%hi, 0.0%si,
>> 0.0%st
>> Mem: 32949816k total, 31333260k used, 1616556k free, 526988k buffers
>> Swap: 4192956k total, 1989136k used, 2203820k free, 9182092k cached
>>
>> PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND
>> 12671 root 25 0 19.8g 19g 1612 R 100.1 62.6 4:31.78 psql

What eats up your memory is "psql", which indeed allocates a whopping
19G physical memory, not the server process.
- Are you sure that is _your_ "psql" selecting "* from customers" and
not somebody else's, doing a cross-join?
- Is there potentially anything that gets TOASTed in your "customer"
table? I'm not sure if that would show up in pg_relation_size and
friends, but it would get sent to psql of course.

Regards,

--
Gunnar "Nick" Bluth
RHCE/SCLA

Mobil +49 172 8853339
Email: gunnar(dot)bluth(at)pro-open(dot)de
__________________________________________________________________________
In 1984 mainstream users were choosing VMS over UNIX. Ten years later
they are choosing Windows over UNIX. What part of that message aren't you
getting? - Tom Payne