Home > mailing lists

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

From	Thalis A. Kalfigopoulos
Subject	shared_buffer=2*max_connections?
Date	July 20, 2001 18:30:41
Msg-id	Pine.LNX.4.21.0107201444480.12926-100000@aluminum.cs.pitt.edu Whole thread Raw
Responses	Re: shared_buffer=2max_connections? Re: shared_buffer=2max_connections?
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:

From: Keith F Irwin
Date: 20 July 2001, 18:25:30
Subject: Does dropping a column from a table mess up foreign keys?

From: markMLl.pgsql-general@telemetry.co.uk
Date: 20 July 2001, 18:36:49
Subject: Re: Migration

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

Previous

Next