Tom,
Sorry, it's 4kb, that explain it.
Thank you,
Regards,
Jie Liang
-Original Message-
From: Tom Lane [mailto:[EMAIL PROTECTED]
Sent: Thursday, January 25, 2007 12:15 PM
To: Jie Liang
Cc: pgsql-sql@postgresql.org
Subject: Re: shared_buffers and shmall,shmmax
> shmall is 65536 page
Tom,
I am trying to tunrn my db server (p4 3.2GHzCPU, 2GB RAM on FreeBSD 5.5,
postgresql 8.1.4), I am trying to increase the share_buffer to 512M 1/4
of RAM, so I set it to shared_buffers=65536 (512M), then failed to
start, then I reduce to 6,4,3, it failed to start database
until 2000
> shmall is 65536 page
And how big is a page?
regards, tom lane
---(end of broadcast)---
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do
