> >>Will more RAM become available to postgresql if I change the
> >>kernel-values mentioned above to half the size?
> >
> >Yes, it will raise the in-kernel limits so that PostgreSQL can
> >allocate more RAM for its user-land cache.
> >
> >You will probably have a better ROI in terms of performance
Sean Chittenden wrote:
Will more RAM become available to postgresql if I change the
kernel-values mentioned above to half the size?
Yes, it will raise the in-kernel limits so that PostgreSQL can
allocate more RAM for its user-land cache.
You will probably have a better ROI in terms of pe
> I recently lowered max_connections from 1024 to 384 in
> /usr/local/pgsql/data/postgresql.conf. The server is a quad opteron @
> 2 GHz and 4 GB of RAM.
>
> This decreased the SIZE and RES values in top and it seems that the
> current max_connections is more than adequate. To see how many
> concu
Hi.
I recently lowered max_connections from 1024 to 384 in
/usr/local/pgsql/data/postgresql.conf. The server is a quad opteron @
2 GHz and 4 GB of RAM.
This decreased the SIZE and RES values in top and it seems that the
current max_connections is more than adequate. To see how many
concurrent con
