> Possibly stopping at the tablespace level might be more straightforward. > To avoid messing up the pages in shared buffers we'd perhaps need > something like several shared buffer pools - each with either its own > blocksize or associated with a (set of) tablespace(s).
This is exactly how Oracle does it. You can specify the blocksize when creating a tablespace. For each blocksize a separate buffer cache ("shared buffers" in Postgres terms) can be configured. So the cache is not maintained on tablespace level but on blocksize level. -- View this message in context: http://postgresql.1045698.n5.nabble.com/parametric-block-size-tp5812350p5813060.html Sent from the PostgreSQL - hackers mailing list archive at Nabble.com. -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers