Re: Processes and caches in postgresql - Mailing list pgsql-hackers

From Craig Ringer
Subject Re: Processes and caches in postgresql
Date
Msg-id CAMsr+YHPBSJspzK8+FChM3WFgNBiWz_yu+HVh_0ccjpVgzXSfA@mail.gmail.com
Whole thread Raw
In response to Re: Processes and caches in postgresql  (Merlin Moncure <mmoncure@gmail.com>)
Responses Re: Processes and caches in postgresql
List pgsql-hackers
On 3 May 2016 at 21:37, Merlin Moncure <mmoncure@gmail.com> wrote:
 

There is library out there, unfortunately GPL licensed, that attempts
to fully implement posix including fork(): http://midipix.org/.  One
of these days I'd like to have a go at porting postgres to it.

... and here I thought you'd be keen to instead remove all use of globals and 'static' locals to allow thread-safe state tracking, remove use of shmem, introduce threaded backends, replace use of signals, and release ThreadedPostgres.

Sounds fun, right? :p

More seriously, shouldn't Microsoft's new (or at least re-blessed and re-released with a new paint job) Linux/POSIX support offer us some options here? I suspect not - they're probably restricted to ELF binaries that won't be able to link to native Windows DLLs to get support for things like SSPI auth, native Windows SSL API use, etc. But it's worth keeping the possibility in mind.

Frankly, a library that implements fork() might cause exciting explosions when using native Windows services, too.

--
 Craig Ringer                   http://www.2ndQuadrant.com/
 PostgreSQL Development, 24x7 Support, Training & Services

pgsql-hackers by date:

Previous
From: "David G. Johnston"
Date:
Subject: Re: full table delete query
Next
From: Craig Ringer
Date:
Subject: Re: pg_dump broken for non-super user