Re: page size in postgresql

Поиск
Список
Период
Сортировка
От Martijn van Oosterhout
Тема Re: page size in postgresql
Дата
Msg-id 20030512040111.GC13479@svana.org
обсуждение исходный текст
Ответ на page size in postgresql  ("sureshk2003" <sureshk2003@indiatimes.com>)
Список pgsql-general
On Mon, May 12, 2003 at 08:49:46AM +0530, sureshk2003 wrote:
> On my machine, getpagesize() returns 4096, so does that
> mean that the page size for postgresql is 4096 bytes?
> The documentation for "Monitoring disk usage" says
> postgres page size is "usually" 8KB (8192 bytes). Which
> one should I use?

The postgresql pagesize is determined at compile time and given that most
people don't fiddle it, it's going to be 8KB in 99.9% of cases.
--
Martijn van Oosterhout   <kleptog@svana.org>   http://svana.org/kleptog/
> "the West won the world not by the superiority of its ideas or values or
> religion but rather by its superiority in applying organized violence.
> Westerners often forget this fact, non-Westerners never do."
>   - Samuel P. Huntington

Вложения

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

Предыдущее
От: "sureshk2003"
Дата:
Сообщение: page size in postgresql
Следующее
От: "D. Dante Lorenso"
Дата:
Сообщение: Serialization, Locking...implement processing Queue with a table