postgres block size alignment with filesystem block size

Поиск
Список
Период
Сортировка
От Mike Broers
Тема postgres block size alignment with filesystem block size
Дата
Msg-id CAB9893gSq_A4njV6XfAeZ_f7ZN4ES3_Qz=Bidq16k90RoRfPsA@mail.gmail.com
обсуждение исходный текст
Ответы Re: postgres block size alignment with filesystem block size
Список pgsql-admin
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



В списке pgsql-admin по дате отправления:

Предыдущее
От: Gabriele Bartolini
Дата:
Сообщение: Re: Postgres 9.1 Synchronous Replication and stuck queries during sync repl setup
Следующее
От: Manoj Govindassamy
Дата:
Сообщение: Re: Postgres 9.1 Synchronous Replication and stuck queries during sync repl setup