Re: page size in postgresql

From: Martijn van Oosterhout <kleptog(at)svana(dot)org>
To: sureshk2003 <sureshk2003(at)indiatimes(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: page size in postgresql
Date: 2003-05-12 04:01:11
Message-ID: 20030512040111.GC13479@svana.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)svana(dot)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message D. Dante Lorenso 2003-05-12 06:07:10 Serialization, Locking...implement processing Queue with a table
Previous Message sureshk2003 2003-05-12 03:19:46 page size in postgresql