On Wed, 6 Aug 2003, Wilson A. Galafassi Jr. wrote: > hello. > my database size is 5GB. what is the block size recommend?
Well, the biggest block size currently supported by stock linux distros is 4k, so I'd go with that. Postgresql's default block size of 8k is fine also. Note that linux page/system/file block sizes are NOT related to Postgresql block sizes. ---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])