Re: parametric block size?

Поиск
Список
Период
Сортировка
От Thomas Kellerer
Тема Re: parametric block size?
Дата
Msg-id 1406564615879-5813060.post@n5.nabble.com
обсуждение исходный текст
Ответ на Re: parametric block size?  (Mark Kirkwood <mark.kirkwood@catalyst.net.nz>)
Список 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.



В списке pgsql-hackers по дате отправления:

Предыдущее
От: Andres Freund
Дата:
Сообщение: Re: Proposal to add a QNX 6.5 port to PostgreSQL
Следующее
От: Christoph Berg
Дата:
Сообщение: Re: [GSoC2014] Patch ALTER TABLE ... SET LOGGED