On 05/27/2013 01:25 PM, Ben Zeev, Lior wrote: > Thanks Atri! > > Do you know why PostgreSQL store the indexes in memory per process and not in > the shared memory? >From shared_buffers point of view tables and indexes are identical, both use the same shared memory in (usually) 8KB pages > Is there a way to prevent it store the indexes data per process, and force it > storing it in the shared memory? It already does.
Per-query sorts and hashtables are stored in local memory, ordinary tables and indexes are in shared. -- Hannu Krosing PostgreSQL Consultant Performance, Scalability and High Availability 2ndQuadrant Nordic OÜ -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
