about effective_cache_size

From: AI Rumman <rummandba(at)gmail(dot)com>
To: pgsql-general General <pgsql-general(at)postgresql(dot)org>
Subject: about effective_cache_size
Date: 2010-02-18 08:09:57
Message-ID: 2a7905441002180009w6ff0ac85mceda69107e9b5e09@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

* What is the difference between shared_buffers and effective_cache_size?

* If I set effective cache size 1GB for db1 and 500 MB for db2, then what
will happen to the system memory usage?

Anyone please tell me.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Jayadevan M 2010-02-18 08:10:22 Re: One solution for Packages in Postgre
Previous Message Carsten Kropf 2010-02-18 07:32:19 Trying to add a type modifier to user created type