Re: [GENERAL] High RAM usage on postgres

2013-03-18 Thread Daniel Verite
Merlin Moncure wrote: > problem is psql buffering whole result set in memory before outputting > result. note this is core problem with libpq client library until > very recently. there are several easy workarounds: > > *) use cursor > *) don't select entire table, page it out using in

Re: [GENERAL] High RAM usage on postgres

2013-03-18 Thread Merlin Moncure
On Thu, Mar 14, 2013 at 1:55 PM, prashantmalik wrote: > Hello, > > We are facing very HIGH memory utilization on postgreSQL server and need > help. > > Total RAM : 32GB > Total CPU : 16cores > > ---

Re: [GENERAL] High RAM usage on postgres

2013-03-17 Thread Gunnar "Nick" Bluth
Am 17.03.2013 09:31, schrieb Scott Marlowe: On Thu, Mar 14, 2013 at 12:55 PM, prashantmalik wrote: *Query :* "SELECT * FROM customer" --- top

Re: [GENERAL] High RAM usage on postgres

2013-03-17 Thread Scott Marlowe
On Thu, Mar 14, 2013 at 12:55 PM, prashantmalik wrote: > Hello, > > We are facing very HIGH memory utilization on postgreSQL server and need > help. > > Total RAM : 32GB > Total CPU : 16cores > > --

[GENERAL] High RAM usage on postgres

2013-03-16 Thread prashantmalik
Hello, We are facing very HIGH memory utilization on postgreSQL server and need help. Total RAM : 32GB Total CPU : 16cores --- *Table Size:* SEL