Re: tune up memory consumption for disk caching - Mailing list pgsql-general

From caldodge@fpcc.net (Calvin Dodge)
Subject Re: tune up memory consumption for disk caching
Date
Msg-id ca6275f0.0201061938.64e6cfcf@posting.google.com
Whole thread Raw
List pgsql-general
rusland@scn.ru (Ruslan A Dautkhanov) wrote in message news:<b8917d78.0201060519.79cba3c3@posting.google.com>...

>   My server have a lot of memory, but PostgreSQL uses
>  only a little amount of this. How I can increase
>  size of internal PG buffers? Or, maybe better to
>  increase size of OS-level buffers?

You want to increase the number of Postgresql buffers by editing
postgresql.conf.

Check out http://www.phpbuilder.com/columns/smith20010821.php3 for a
good short article on the subject.

Calvin

pgsql-general by date:

Previous
From: "Johnson, Shaunn"
Date:
Subject: Re: Tuple too big ?
Next
From: Martijn van Oosterhout
Date:
Subject: Re: Turning off transactions completely.