Re: Estimating total amount of shared memory required by postmaster - Mailing list pgsql-hackers

From Alvaro Herrera
Subject Re: Estimating total amount of shared memory required by postmaster
Date
Msg-id 1307074462-sup-635@alvh.no-ip.org
Whole thread Raw
In response to Re: Estimating total amount of shared memory required by postmaster  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
Excerpts from Tom Lane's message of jue jun 02 15:49:53 -0400 2011:

> The results of such a test wouldn't be worth the electrons they're
> written on anyway: you're ignoring the likelihood that two instances of
> shared memory would overrun the kernel's SHMALL limit, when a single
> instance would be fine.

Well, overrunning SHMALL sets a different errno than overrunning SHMMAX,
so at least it's possible to notice the problem.

> Given that you can't do it in the context of a live installation, just
> trying to start the postmaster and seeing if it works (same as initdb
> does) seems as good as anything else.

That's precisely what this is trying to avoid.

-- 
Álvaro Herrera <alvherre@commandprompt.com>
The PostgreSQL Company - Command Prompt, Inc.
PostgreSQL Replication, Consulting, Custom Development, 24x7 support


pgsql-hackers by date:

Previous
From: Jim Nasby
Date:
Subject: Re: storing TZ along timestamps
Next
From: Robert Haas
Date:
Subject: Re: Domains versus polymorphic functions, redux