On Wed, Jan 7, 2009 at 3:23 AM, Tom Lane wrote:
> "Frank Joerdens" writes:
>> then I take the request size value from the error and do
>> echo 8810725376 > /proc/sys/kernel/shmmax
>> and get the same error again.
>
> What about shmall?
Yes that works, it was set to
r...@db04:~# cat /proc/sys/ke
"Frank Joerdens" writes:
> then I take the request size value from the error and do
> echo 8810725376 > /proc/sys/kernel/shmmax
> and get the same error again.
What about shmall?
regards, tom lane
--
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.
Tom Lane wrote:
> "Ryan Hansen" writes:
[...]
>> but when I set the shared buffer in PG and restart
>> the service, it fails if it's above about 8 GB.
>
> Fails how? And what PG version is that?
The thread seems to end here as far as the specific question was
concerned. I just ran into the same
