Re: SYSV shared memory vs mmap performance

From: Robert Haas <robertmhaas(at)gmail(dot)com>
To: Bruce Momjian <bruce(at)momjian(dot)us>
Cc: Francois Tigeot <ftigeot(at)wolfpond(dot)org>, pgsql-hackers(at)postgresql(dot)org
Subject: Re: SYSV shared memory vs mmap performance
Date: 2013-01-25 13:47:51
Message-ID: CA+TgmoZW3wte8anFqNroT0R9MjLmTPGJr09=3O_1+iVKYzMzeg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Fri, Jan 25, 2013 at 8:40 AM, Bruce Momjian <bruce(at)momjian(dot)us> wrote:
> Just a reminder we might have *BSD performance issues with our use of
> Posix shared memory in Postgres 9.3. I am attaching the PDF the user
> posted.

This is a good point. The question which I believe I asked before and
haven't gotten an answer to is whether there's some way to get the
benefit of shm_use_phys with an anonymous mapping.

It seems to me to be slightly insane to impose draconian shared memory
limits out of the box and then complain when people switch to some
other type of shared memory to get around them. I realize that
Dragonfly may not be doing that (because I think they may have raised
the default shared-memory limits), but I believe some of the more
mainstream BSDs are.

I suppose we could add a GUC for this, but that's not very appealing, either.

--
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Bruce Momjian 2013-01-25 13:53:12 Re: SYSV shared memory vs mmap performance
Previous Message Robert Haas 2013-01-25 13:43:19 Re: pgsql: Make pg_dump exclude unlogged table data on hot standby slaves