Re: [Pgbuildfarm-members] guppie: 64MB RAM too small? - Mailing list pgsql-hackers

From Tom Lane
Subject Re: [Pgbuildfarm-members] guppie: 64MB RAM too small?
Date
Msg-id 16787.1142953180@sss.pgh.pa.us
Whole thread Raw
In response to Re: [Pgbuildfarm-members] guppie: 64MB RAM too small?  (Andrew Dunstan <andrew@dunslane.net>)
Responses Re: [Pgbuildfarm-members] guppie: 64MB RAM too small?  ("Jim C. Nasby" <jnasby@pervasive.com>)
List pgsql-hackers
Andrew Dunstan <andrew@dunslane.net> writes:
> At the time it sets max_connections there is no server to test against. 
> initdb in fact never uses a standard client connection at all, and never 
> starts postmaster. To do a check on max_connections you would have to 
> start postmaster and then try to start that many client connections. 

max_connections *is* checked by initdb ... although only to the extent
of verifying we can make that many semaphores.

The parallel regression tests are not a particularly great reference
point for this anyway, because for each parallel test case you have not
only a server process, but a psql process, and in most shells a parent
shell process for the psql, ie 3x the nominal level of parallelism,
all running under the postgres userid.  This isn't the normal usage
scenario, so it would not be reasonable to restrict max_connections to
1/3 the number of user processes per userid.
        regards, tom lane


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: [Pgbuildfarm-members] guppie: 64MB RAM too small?
Next
From: Magnus Jonsson
Date:
Subject: Problems with CREATE AGGREGATE and user defined state type.