First my system is a icore 7 920 on an asus desktop mobo with 12 gigs of ddr3 1600. I use vista 64 bit which is on a sas drive. I have two ocz vertex's in raid 0 which i have my databse on. What is best stripe size, cluster size(unit allocation size) and postgresql block size for this. Database gets from 40gb to over 100gb. Query return speeds are important. AM sort of a noob but have been using postgresql for years but i dont program anything.
AM also wondering what is best settings in postgresql.conf file to change and to what to. HAve read tons ot try to understand this but am still sort of lost. thanks for any help