Re: [PERFORM] postgresql recommendation memory

2013-11-07 Thread Евгений Селявка
All my sar statistics sar -r 11:40:02 AM kbmemfree kbmemused %memused kbbuffers kbcached kbcommit %commit 01:15:01 PM269108 32608084 99.18367144 29707240 10289444 27.83 01:20:01 PM293560 32583632 99.11367428 29674272 10287136 27.82 01:25:01 PM417640 32459552

Re: [PERFORM] postgresql recommendation memory

2013-11-07 Thread Евгений Селявка
Scott thank you for advice. > If you've got one job that needs lots of mem and lot of jobs that > don't, look at my recommendation to lower work_mem for all the low mem > requiring jobs. If you can split those heavy lifting jobs out to > another user, then you can use a pooler like pgbouncer to do

Re: [PERFORM] postgresql recommendation memory

2013-11-07 Thread David Rees
On Wed, Nov 6, 2013 at 8:35 AM, Scott Marlowe wrote: > That's a mostly religious argument. I.e. you're going on feeling here > that pooling in jdbc alone is better than either jdbc/pgbouncer or > plain pgbouncer alone. My experience is that jdbc pooling is not in > the same category as pgbouncer f