Re: Tablespace-level Block Size Definitions - Mailing list pgsql-hackers

From Dawid Kuroczko
Subject Re: Tablespace-level Block Size Definitions
Date
Msg-id 758d5e7f05060105006f2e296a@mail.gmail.com
Whole thread Raw
In response to Re: Tablespace-level Block Size Definitions  ("Zeugswetter Andreas DAZ SD" <ZeugswetterA@spardat.at>)
Responses Re: Tablespace-level Block Size Definitions
List pgsql-hackers
On 6/1/05, Zeugswetter Andreas DAZ SD <ZeugswetterA@spardat.at> wrote:
> 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 ?

Well, I don't think it is much different from having two database clusters,
each with different block size.  Hmm, perhaps it could be possible to
make them all available through one "virtual" DB host/port using
pg_pool even. :)

It shouldn't be too difficult to create benchmarks testing performance
of PostgreSQL under different block sizes, I guess.  I wonder what
perfromance win is possible...
  Regards,     Dawid


pgsql-hackers by date:

Previous
From: Simon Riggs
Date:
Subject: Re: NOLOGGING option, or ?
Next
From: Simon Riggs
Date:
Subject: Re: NOLOGGING option, or ?