Re: Enough RAM for entire Database.. cost aside, is this

From: "Andy B" <abhousehuntRE-M--O--V-E(at)blueyonder(dot)co(dot)uk>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Enough RAM for entire Database.. cost aside, is this
Date: 2004-07-02 12:04:39
Message-ID: rbcFc.6326$HQ1.5177@fe2.news.blueyonder.co.uk
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello Shridhar,

Thanks for the reply.

> There is no reason why you should not do it. How remains to be a point of
> disagreement though. You don't allocate 16GB of shared buffers to
postgresql.
> That won't give you performance you need.

I think in the other thread, Tom was alluding to this too. What is it about
the shared buffer cache behaviour that makes it inefficient when it is very
large? (assuming that the address space it occupies is allocated to RAM
pages)

Is there a good place I could look for some in depth details of its
behaviour?

Many thanks,
Andy

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Juan Jose Costello Levien 2004-07-02 12:56:43 Re: Row values
Previous Message Stephen Liu 2004-07-02 11:56:09 How to add an userA to login postgresadmin