On 6/1/05, Zeugswetter Andreas DAZ SD <[EMAIL PROTECTED]> 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 ---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend