Re: Tablespace-level Block Size Definitions

From: "Zeugswetter Andreas DAZ SD" <ZeugswetterA(at)spardat(dot)at>
To: "Alvaro Herrera" <alvherre(at)surnet(dot)cl>, "Jonah H(dot) Harris" <jharris(at)tvi(dot)edu>
Cc: <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Tablespace-level Block Size Definitions
Date: 2005-06-01 11:07:57
Message-ID: E1539E0ED7043848906A8FF995BDA5790C5186@m0143.s-mxs.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Mark Cave-Ayland 2005-06-01 11:18:12 Re: Quick-and-dirty compression for WAL backup blocks
Previous Message Hannu Krosing 2005-06-01 09:54:58 Re: NOLOGGING option, or ?