Re: memory - Mailing list pgsql-novice

From Richard Broersma Jr
Subject Re: memory
Date
Msg-id 105180.7384.qm@web31809.mail.mud.yahoo.com
Whole thread Raw
In response to Re: memory  (Tom Allison <tallison@tacocat.net>)
List pgsql-novice
> 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.

pgsql-novice by date:

Previous
From: Tom Allison
Date:
Subject: Re: memory
Next
From: "Guido Barosio"
Date:
Subject: Re: memory