2010/10/28 Francisco Reyes <li...@stringsutils.com>: > Greg Smith writes: > >> heard privately from two people who have done similar experiments on Linux >> and found closer to 8GB to be the point where performance started > > So on a machine with 72GB is 8GB still the recommended value?
Yes, as a maximum, not a minimum. (Some applications will work better with less shared_buffers than others) > Usually have only 10 to 20 connections. > -- > Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-performance > -- Cédric Villemain 2ndQuadrant http://2ndQuadrant.fr/ PostgreSQL : Expertise, Formation et Support -- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
