Postgres Pro
Downloads
Home   >   mailing lists

What size of block should I choose? - Mailing list pgsql-general

From Roman Havrylyak
Subject What size of block should I choose?
Date
Msg-id 9tg3lg$20ot$1@news.tht.net
Whole thread Raw
List pgsql-general
Tree view 
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

pgsql-general by date:

Previous
From: Eric Cholet
Date:
Subject: Determining which index to create
Next
From: Martijn van Oosterhout
Date:
Subject: Re: Determining which index to create