Re: postgresql recommendation memory - Mailing list pgsql-performance

From Josh Berkus
Subject Re: postgresql recommendation memory
Date
Msg-id 52794E3D.1070700@agliodbs.com
Whole thread Raw
In response to postgresql recommendation memory  (Евгений Селявка <evg.selyavka@gmail.com>)
List pgsql-performance
> PostgreSQL 9.1.6 on x86_64-unknown-linux-gnu, compiled by gcc (GCC) 4.4.6
> 20120305 (Red Hat 4.4.6-4), 64-bit

First, you should be using the latest update version.  You are currently
missing multiple patch updates.

> listen_addresses = '*'
> port = 5433
> max_connections = 350
> shared_buffers = 8GB

Try dropping shared_buffers to 2GB.  We've seen some issues on certain
systems with 8GB shared buffers.

--
Josh Berkus
PostgreSQL Experts Inc.
http://pgexperts.com


pgsql-performance by date:

Previous
From: Merlin Moncure
Date:
Subject: Re: Trees: integer[] outperformed by ltree
Next
From: Jan Walter
Date:
Subject: Re: Trees: integer[] outperformed by ltree