Re: tune up memory consumption for disk caching

From: caldodge(at)fpcc(dot)net (Calvin Dodge)
To: pgsql-general(at)postgresql(dot)org
Subject: Re: tune up memory consumption for disk caching
Date: 2002-01-07 03:38:31
Message-ID: ca6275f0.0201061938.64e6cfcf@posting.google.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

rusland(at)scn(dot)ru (Ruslan A Dautkhanov) wrote in message news:<b8917d78(dot)0201060519(dot)79cba3c3(at)posting(dot)google(dot)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

Browse pgsql-general by date

  From Date Subject
Next Message Ed Yu 2002-01-07 05:02:09 Re: create table with multiple unique fields
Previous Message Johnson, Shaunn 2002-01-06 16:36:48 Re: Tuple too big ?