Milen, On 8/1/06 3:19 PM, "Milen Kulev" <makulev@xxxxxxx> wrote: > Sorry, forgot to ask: > What is the recommended/best PG block size for DWH database? 16k, 32k, 64k > ? > What hsould be the relation between XFS/RAID stripe size and PG block size ? We have found that the page size in PG starts to matter only at very high disk performance levels around 1000MB/s. Other posters have talked about maintenance tasks improving in performance, but I haven't seen it. - Luke
