Re: Tablespace-level Block Size Definitions

Поиск
Список
Период
Сортировка
От Zeugswetter Andreas DAZ SD
Тема Re: Tablespace-level Block Size Definitions
Дата
Msg-id E1539E0ED7043848906A8FF995BDA5790C5186@m0143.s-mxs.net
обсуждение исходный текст
Ответ на Tablespace-level Block Size Definitions  ("Jonah H. Harris" <jharris@tvi.edu>)
Ответы Re: Tablespace-level Block Size Definitions
Список pgsql-hackers
> The problem I see with this proposal is that the buffer manager knows
> how to handle only a equally-sized pages.  And the shared memory stuff
> gets sized according to size * num_pages.  So what happens if a certain
> tablespace A with pagesize=X gets to have a lot of its pages cached,
> evicting pages from tablespace B with pagesize=Y, where Y < X?

You could create a separate bufferpool per page size. Of course that
has other disadvantages.

Is it really so difficult to create and attach another shmem segment ?

Andreas


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

Предыдущее
От: Hannu Krosing
Дата:
Сообщение: Re: NOLOGGING option, or ?
Следующее
От: "Mark Cave-Ayland"
Дата:
Сообщение: Re: Quick-and-dirty compression for WAL backup blocks