Re: PostgreSQL Process memory architecture - Mailing list pgsql-hackers

From Stephen Frost
Subject Re: PostgreSQL Process memory architecture
Date
Msg-id 20130527121821.GG8597@tamriel.snowman.net
Whole thread Raw
In response to Re: PostgreSQL Process memory architecture  ("Ben Zeev, Lior" <lior.ben-zeev@hp.com>)
List pgsql-hackers
Lior,

* Ben Zeev, Lior (lior.ben-zeev@hp.com) wrote:
> Do you know why PostgreSQL store the indexes in memory per process and not in the shared memory?

The disk blocks from an index are not stored per-process, they are kept
in shared memory.  When building an index, PG can only use one process
and so there isn't any point having that be in shared memory.
Thanks,
    Stephen

pgsql-hackers by date:

Previous
From: Atri Sharma
Date:
Subject: Re: PostgreSQL Process memory architecture
Next
From: Atri Sharma
Date:
Subject: Re: PostgreSQL Process memory architecture