Re: PostgreSQL Process memory architecture

From: Stephen Frost <sfrost(at)snowman(dot)net>
To: "Ben Zeev, Lior" <lior(dot)ben-zeev(at)hp(dot)com>
Cc: Atri Sharma <atri(dot)jiit(at)gmail(dot)com>, Pg Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: PostgreSQL Process memory architecture
Date: 2013-05-27 12:18:21
Message-ID: 20130527121821.GG8597@tamriel.snowman.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Lior,

* Ben Zeev, Lior (lior(dot)ben-zeev(at)hp(dot)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

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Atri Sharma 2013-05-27 12:18:36 Re: PostgreSQL Process memory architecture
Previous Message Atri Sharma 2013-05-27 12:16:28 Re: PostgreSQL Process memory architecture