basic question (shared buffers vs. effective cache size)

From: "Sally Sally" <dedeb17(at)hotmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: basic question (shared buffers vs. effective cache size)
Date: 2004-05-10 15:45:01
Message-ID: BAY9-F47Ll6RmonDAPk0001c281@hotmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I have a very basic question on the two parameters shared buffers and
effective cache size. I have read articles on what each is about etc. But I
still think I don't quite grasp what these settings mean (especially in
relation to each other). Since these two settings seem crucial for
performance can somebody explain to me the relationship/difference between
these two settings and how they deal with shared memory.
Thanks much
Sally

_________________________________________________________________
Is your PC infected? Get a FREE online computer virus scan from McAfee
Security. http://clinic.mcafee.com/clinic/ibuy/campaign.asp?cid=3963

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Andrew Sullivan 2004-05-10 16:09:39 Re: vacuumdb is failing with NUMBER OF INDEX TUPLES NOT
Previous Message Carl E. McMillin 2004-05-10 15:31:04 Re: Cancel query based on a timeout