On Mon, Oct 11, 2010 at 11:11 PM, <gnuo...@rcn.com> wrote: > An approach that works can be found in DB2, and likely elsewhere. > > The key is that tablespaces/tables/indexes/buffers are all attached through > the bufferpool (the DB2 term). A tablespace/bufferpool match is defined. > Then tables and indexes are assigned to the tablespace (and implicitly, the > bufferpool). As a result, one can effectively pin data in memory. This is > very useful, but not low hanging fruit to implement. > > The introduction of rudimentary tablespaces is a first step. I assumed that > the point was to get to a DB2-like structure at some point. Yes?
We already have tablespaces, and our data already is accessed through the buffer pool. -- Robert Haas EnterpriseDB: http://www.enterprisedb.com The Enterprise PostgreSQL Company -- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance