Thread: What size of block should I choose?

What size of block should I choose?

From
"Roman Havrylyak"
Date:
Hi all

I am installing RAID 1+0 (strip + mirroring) with 4 HDDs and have to choose
what size of block will best suite for my PostgreSQL database. Average size
of file-table is 50Mb, average count of records per table is about 50 000.

Available options are: 16k, 32k, 64k, ... 512k

Any suggestions?

WBR, Roman Havrylyak