Postgres Pro
Downloads
Home   >   mailing lists

shared_buffer=2*max_connections? - Mailing list pgsql-general

From Thalis A. Kalfigopoulos
Subject shared_buffer=2*max_connections?
Date
Msg-id Pine.LNX.4.21.0107201444480.12926-100000@aluminum.cs.pitt.edu
Whole thread Raw
Responses Re: shared_buffer=2*max_connections?  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: shared_buffer=2*max_connections?  (Bruce Momjian <pgman@candle.pha.pa.us>)
List pgsql-general
Tree view 
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
thesize of the query->involved relations, the sort_mem size etc.etc. 

True/false?

TIA,
thalis

pgsql-general by date:

Previous
From: Keith F Irwin
Date:
Subject: Does dropping a column from a table mess up foreign keys?
Next
From: markMLl.pgsql-general@telemetry.co.uk
Date:
Subject: Re: Migration