Search Postgresql Archives

config file question between versions 7.4 - 9.1

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

To: pgsql-general <pgsql-general@xxxxxxxxxxxxxx>
Subject: config file question between versions 7.4 - 9.1
From: Randy Johnson <randy.johnson@xxxxxxxxxxxxxxxx>
Date: Wed, 9 May 2012 11:11:23 -0400

Hello,

in the config file for 7.4 we have an entry:

shared_buffers = 1000 # min 16, at least max_connections*2, 8KB each

in 9.1 the default is:

shared_buffers = 32MB

max connections is the default 100

Do I need to make any adjustments or can I leave it at the default?

The machine is dedicated to Postgres and has 8GB of memory and a default install of 9.1 and 7.4 doesn't appear to have any custom configuration.

Thanks!

Randy

Follow-Ups:
- Re: config file question between versions 7.4 - 9.1
  - From: Albe Laurenz

Prev by Date: Re: Strange crash logs
Next by Date: Re: Issue with rsync based incremental backup : postgres: startup process waiting for 0000000100000001000000D2
Previous by thread: Strange crash logs
Next by thread: Re: config file question between versions 7.4 - 9.1
Index(es):
- Date
- Thread

[Postgresql Jobs] [Postgresql Admin] [Postgresql Performance] [Linux Clusters] [PHP Home] [PHP on Windows] [Programming PHP] [Kernel Newbies] [PHP Classes] [Find Someone Nice] [PHP Books] [PHP Databases] [Postgresql & PHP] [Yosemite]

Add to Google

Powered by Linux