Re: Page Size in Future Releases

Поиск
Список
Период
Сортировка
От Christopher Kings-Lynne
Тема Re: Page Size in Future Releases
Дата
Msg-id 08ac01c2ef5d$3487fec0$6500a8c0@fhp.internal
обсуждение исходный текст
Ответ на Page Size in Future Releases  ("Kendrick C. Wilson" <kendrick_wilson@hotmail.com>)
Список pgsql-performance
> > I have records about 881 byte + 40 byte (header) = 921.
> >
> > 8k page size / 921 bytes per record is ONLY 8 records...........
>
> You can tweak it yourself at compile time in some header file and that
should
> work but that is a point of diminising results as far as hackers are
> concerned.

As far as I'm aware the 8k page size has nothing to do with speed and
everything to do with atomic writes.  You can't be guaranteed that the O/S
and hard drive controller will write anything more than 8K in an atomic
block...

Chris


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

Предыдущее
От: "Shridhar Daithankar"
Дата:
Сообщение: Re: postgresql meltdown on PlanetMath.org
Следующее
От: Josh Berkus
Дата:
Сообщение: Re: Page Size in Future Releases