> > > > 32 buffers = 1MB with 32KB blocksize, which spoils the CPU L2 > > > > cache effect.
I'd say in a scenario where 32k pages are indicated you will also want larger than average L2 caches. > > > > > > > > How about using 256/blocksize? The reading ahead uses 1/4 ring size. To the best of our knowledge, this 1/4 needs to be 128k for reading. So I'd say we need 512/blocksize. Andreas ---------------------------(end of broadcast)--------------------------- TIP 7: You can help support the PostgreSQL project by donating at http://www.postgresql.org/about/donate