Search Postgresql Archives

Shared Memory/Shared Buffers

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



I have noticed that I can't set the shared buffers above 15512 which
is exactly 128MB of RAM.  Even if I set /proc/sys/kernel/shmmax above
that, postgres refuses to start with a setting over 128MB.

Anyone have any ideas about this?

I guess there are a couple of questions - would I ever need a shared
buffers setting over 128MB?  And if I do, how can I set it?  The
database performs a lot of searches that are very heavy on seq scans
on a couple of tables, one with 35k rows that joins agains one with 2m
rows.  The results are always sorted.

The system is Running SuSe 9.2 with kernel 2.6.8 on 2xAMD Opteron with 4GB RAM

Alex Turner
NetEconomist

---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

               http://www.postgresql.org/docs/faq

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux