shared_buffer=2*max_connections?

From: "Thalis A(dot) Kalfigopoulos" <thalis(at)cs(dot)pitt(dot)edu>
To: pgsql-general(at)postgresql(dot)org
Subject: shared_buffer=2*max_connections?
Date: 2001-07-20 18:58:09
Message-ID: Pine.LNX.4.21.0107201444480.12926-100000@aluminum.cs.pitt.edu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I see in postgresql.conf what seems to be the suggested way to go:

#shared_buffers = 2*max_connections # min 16

This seems to imply that every connection is to take 16kb of shmem on average. From my understanding this depends on the size of the query->involved relations, the sort_mem size etc.etc.

True/false?

TIA,
thalis

Responses

Browse pgsql-general by date

  From Date Subject
Next Message markMLl.pgsql-general 2001-07-20 19:02:37 Re: Migration
Previous Message Stephan Szabo 2001-07-20 18:50:49 Re: Postgres User and Password