Re: PostgreSQL Process memory architecture

Thanks Atri!

Do you know why PostgreSQL store the indexes in memory per process and not in the shared memory?
Is there a way to prevent it store the indexes data per process, and force it storing it in the shared memory?

Lior



-----Original Message-----
From: Atri Sharma [mailto:atri.jiit@gmail.com]
Sent: Monday, May 27, 2013 13:19
To: Ben Zeev, Lior; Pg Hackers
Subject: Re: [HACKERS] PostgreSQL Process memory architecture

On Mon, May 27, 2013 at 3:41 PM, Ben Zeev, Lior <lior.ben-zeev@hp.com> wrote:
> Hi Atri,
>
> Thanks for your answer!
> Do you have idea what may be the reason that PostgreSQL process consume more memory when there are more partial
indexeson the DB table? 


Well, I am not too sure, but indexes always take up more space, so if your backend has a lot of indexes, it will cause
theprocess to consume more memory. 

Indexes should be used with care, as too many indexes can cause a memory overhead,which can cause performance
degradations.

Regards,

Atri

--
Regards,

Atri
l'apprenant