public inbox for [email protected]  

help / color / mirror / Atom feed

From: Tom Lane <[email protected]>
To: Nailah Ogeer <[email protected]>
Cc: [email protected]
Subject: Re: Multiple Buffer pools
Date: Mon, 12 May 2003 13:26:28 -0400
Message-ID: <[email protected]> (raw)
In-Reply-To: <Pine.SOL.4.33.0305121242520.915-100000@innovate>
References: <Pine.SOL.4.33.0305121242520.915-100000@innovate>

Nailah Ogeer <[email protected]> writes:
> I am currently undergoing the project of making postgres's single buffer
> pool into multiple buffer pools hopefully to decrease the number of
> physical reads. Just wondering if anyone has done some work on this
> before.

To be honest, I think this is a complete waste of effort, as the optimal
buffering scheme for Postgres relies on OS-level caching more than
PG-internal caching.  But yes, it's been discussed before.  See the
archives for pgsql-performance and pgsql-hackers.

> Also, I need some information on where the number of relations in
> the system is defined.

There is no very practical way to determine that.  Any one backend can
only see one database, not the entire cluster; and at the time shared
memory is sized, you don't have any database access capability at all.

			regards, tom lane

view thread (2+ messages)

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: [email protected]
  Cc: [email protected], [email protected]
  Subject: Re: Multiple Buffer pools
  In-Reply-To: <[email protected]>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox