> I changed the shmmax to ~442MB and changed the shared_buffers from 3000 to 52000.
> The database is MUCH faster, less load on the cpu, but takes 50% of the RAM.
> I don't know how much of the data is cached per se -- but it's an improvement.
>
> Now I probably have to worry about using too much memory...
If you want to have large shared_buffers but not use too much memory, just reduce max_connections
to a reasonable number.
Regards,
Richard Broersma Jr.