[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

postgres block size alignment with filesystem block size



Hello, I am setting up a new postgres production server in a managed hosting environment.  I dont have much insight into the underlying disk architecture but the filesystem I have been presented with has a 4k block size.  Postgres defaults to 8k block size; would it be beneficial to repave the filesystem at an 8k block size or problematic to leave it at 4k?   I have seen posts suggesting alignment of the postgres block size and the file system block size and the raid block size, but wonder if a multiple is sufficient or if it should match exactly.

Thank you
Mike




[Postgresql General]     [Postgresql Performance]     [Postgresql PHP]     [Postgresql Jobs]     [PHP Users]     [PHP Databases]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Databases]     [Yosemite]

Powered by Linux