Rafael Domiciano <rafael.domiciano@xxxxxxxxx> wrote: > So, what's a good value to set to effective_cache_size with 10 Gb > RAM? It depends on how many other things you have on the system which are using RAM, but probably something around 9GB would be appropriate. Maybe even 9.5GB. -Kevin -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin