public inbox for [email protected]  

help / color / mirror / Atom feed

Multiple Buffer pools
2+ messages / 2 participants
[nested] [flat]

* Multiple Buffer pools
@ 2003-05-12 16:45  Nailah Ogeer <[email protected]>
  0 siblings, 1 reply; 2+ messages in thread

From: Nailah Ogeer @ 2003-05-12 16:45 UTC (permalink / raw)
  To: pgsql-docs

Hi,
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. Also, I need some information on where the number of relations in
the system is defined.
thanks a lot
nailah




^ permalink  raw  reply  [nested|flat] 2+ messages in thread

* Re: Multiple Buffer pools
@ 2003-05-12 17:26  Tom Lane <[email protected]>
  parent: Nailah Ogeer <[email protected]>
  0 siblings, 0 replies; 2+ messages in thread

From: Tom Lane @ 2003-05-12 17:26 UTC (permalink / raw)
  To: Nailah Ogeer <[email protected]>; +Cc: pgsql-docs

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





^ permalink  raw  reply  [nested|flat] 2+ messages in thread

end of thread, other threads:[~2003-05-12 17:26 UTC | newest]

Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2003-05-12 16:45 Multiple Buffer pools Nailah Ogeer <[email protected]>
2003-05-12 17:26 ` Tom Lane <[email protected]>

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