Re: [ADMIN] postgres block size alignment with filesystem block size

2012-06-13 Thread Bruce Momjian
On Wed, Jun 06, 2012 at 12:24:35PM -0400, Tom Lane wrote: > Mike Broers writes: > > 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

Re: [ADMIN] postgres block size alignment with filesystem block size

2012-06-06 Thread Tom Lane
Mike Broers writes: > 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

[ADMIN] postgres block size alignment with filesystem block size

2012-06-06 Thread Mike Broers
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 file