Обсуждение: page size in postgresql

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?

Thanks in advance,

SK



Get Your Private, Free E-mail from Indiatimes at http://email.indiatimes.com

 Buy The Best In BOOKS at http://www.bestsellers.indiatimes.com

Bid for for Air Tickets @ Re.1 on Air Sahara Flights. Just log on to http://airsahara.indiatimes.com and Bid Now!

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