Yes, that is understandable. I'm not sure that there is a robust
portable solution that doesn't involve a major rearchitecture. I'm not
sure that would be worth the risk given the reward.
On Apr 2, 2008, at 8:50 AM, Bruce Momjian wrote:
> The original patch author:
> Chris Marcellino <cmarcellino(at)apple(dot)com>
> was not CC'ed as part of this email thread. That was a mistake.
> the email thread discussing your patch is here:
> Please read the discussion --- the bottom line is that there isn't
> support for the patch. Magnus was able to do the POSIX usage without
> relying on shared memory, but I just talked to him via IM and he
> said it
> used a Win32-specific feature that isn't portable to Unix.
> I am holding this patch for the next commit fest in hopes you can
> it, but if not the patch will be rejected at that time.
> Stephen Frost wrote:
> -- Start of PGP signed section.
>> Chris, et al,
>> (commit-fest consensus discussion)
>> * Chris Marcellino wrote:
>>> In case you haven't had enough, here is another version of the code
>>> to make Postgres use POSIX shared memory. Along with the issues that
>>> have already been addressed, this version ensures that orphaned
>>> backends are not in the database when restarting Postgres by using a
>>> single 1 byte SysV segment to see who is attached to the segment
>>> using shmctl/IPC_STAT/nattach.
>> This really feels like a deal-breaker to me. My first reaction to
>> patch, honestly, is that it's being justified for all the wrong
>> Changing to POSIX shm seems like a reasonable goal in general,
>> it can do what we need, but doing it to work around silly defaults
>> doesn't really work for me. If the real issue you have is with the
>> limits then I'd suggest you bring that up with the kernel/
>> folks to get them to use something more sane.
>> Looking around a bit, it looks like it's already being addressed in
>> places, for example Solaris 10 apparently uses 1/4th of memory, while
>> Centos 5 uses 4GB. Suse also uses a larger default, from what I
>> understand. Supporting this effort to get it raised on various
>> platforms and distributions seems like a much better approach.
>> Additionally, it strikes me that there *is* a limit on POSIX shared
>> memory too, generally half of ram on the systems I've looked at, but
>> there's no guarentee that'll always be the default or that half of
>> will always be enough for us. So, even with this change, the problem
>> isn't completely 'solved'.
>> Finding a way for POSIX shm to do what we need, including Tom's
>> concerns, without depending on SvsV shm as a crutch work around,
>> make this change much more reasonable and could be justified as
>> to a well defined POSIX standard, and means we may be able to support
>> platforms which either are new and don't implement SysV but just
>> or cases where SysV is being actively depreceated. Neither of
>> which is
>> possible if we're stuck with using it in some cases.
> -- End of PGP section, PGP failed!
> Bruce Momjian <bruce(at)momjian(dot)us> http://momjian.us
> EnterpriseDB http://enterprisedb.com
> + If your life is a hard drive, Christ can be your backup. +
In response to
pgsql-hackers by date
|Next:||From: Tom Lane||Date: 2008-04-02 15:58:02|
|Subject: Re: varadic patch |
|Previous:||From: Bruce Momjian||Date: 2008-04-02 15:51:33|
|Subject: Re: varadic patch|
pgsql-patches by date
|Next:||From: chris.johnson||Date: 2008-04-02 16:43:22|
|Subject: Patch to add a feature to pg_standby|
|Previous:||From: Brendan Jurd||Date: 2008-04-02 15:52:23|
|Subject: Re: Consistent \d commands in psql|