From: | Евгений Селявка <evg(dot)selyavka(at)gmail(dot)com> |
---|---|
To: | Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com>, "pgsql-performance(at)postgresql(dot)org" <pgsql-performance(at)postgresql(dot)org> |
Subject: | Re: postgresql recommendation memory |
Date: | 2013-11-11 08:09:14 |
Message-ID: | CAKPhvNZhD8Z8QKe6bmvY=hhT2Ejgwrmxn4zcKGjpNgZ7VCyZ=A@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-performance |
Scott hi, i calculate all of my jdbc pool size. Maximum is 300 connections
from components wich use jdbc. I don't think that this is a good idea use
pgbouncer, because our application using spring framework which using jdbc
and prepared statement. I try to talk with our developer about disabling
prepared statement in this framework, they don't want do this. Thats why i
will try to upgrade HW and buy CPU with more core as you say based on
formula 3-4xcore. But most of this connection is idle. This is a web based
app not a datawarehouse, thats why all this connection is lightwear.
About my db freeze i set this kernel parameter:
echo 1048576 > /proc/sys/vm/min_free_kbytes
echo 80 > /proc/sys/vm/vfs_cache_pressure
And my freeze intervals is steel smaller. I try to dig deeper.
2013/11/6 Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com>
> Also also, the definitive page for postgres and dirty pages etc is here:
>
> http://www.westnet.com/~gsmith/content/linux-pdflush.htm
>
> Not sure if it's out of date with more modern kernels. Maybe Greg will
> chime in.
>
--
С уважением Селявка Евгений
From | Date | Subject | |
---|---|---|---|
Next Message | Jan Walter | 2013-11-11 13:56:23 | Re: Size of IN list affects query plan |
Previous Message | Sergey Konoplev | 2013-11-11 00:20:35 | Re: postgresql recommendation memory |