From: | Thomas Kellerer <spam_eater(at)gmx(dot)net> |
---|---|
To: | pgsql-hackers(at)postgresql(dot)org |
Subject: | Re: parametric block size? |
Date: | 2014-07-28 16:23:35 |
Message-ID: | 1406564615879-5813060.post@n5.nabble.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
> 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.
From | Date | Subject | |
---|---|---|---|
Next Message | Christoph Berg | 2014-07-28 16:41:45 | Re: [GSoC2014] Patch ALTER TABLE ... SET LOGGED |
Previous Message | Andres Freund | 2014-07-28 16:22:18 | Re: Proposal to add a QNX 6.5 port to PostgreSQL |