From: | Daniel Farina <daniel(at)heroku(dot)com> |
---|---|
To: | Peter Eisentraut <peter_e(at)gmx(dot)net> |
Cc: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Josh Berkus <josh(at)agliodbs(dot)com>, pgsql-hackers(at)postgresql(dot)org |
Subject: | Re: Proof of concept: standalone backend with full FE/BE protocol |
Date: | 2012-09-06 00:11:23 |
Message-ID: | CAAZKuFbFF+_=ibw4Hd_NRmtxiNEs34ZfR-=kdn_1+dSTB6Apsg@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
On Wed, Sep 5, 2012 at 3:17 PM, Peter Eisentraut <peter_e(at)gmx(dot)net> wrote:
> On 9/5/12 5:59 PM, Daniel Farina wrote:
>> I agree with this, even though in theory (but not in practice)
>> creative use of unix sockets (sorry windows, perhaps some
>> port-allocating and URL mangling can be done instead) and conventions
>> for those would allow even better almost-like-embedded results,
>> methinks. That may still be able to happen.
>
> Sure, everyone who cares can already do this, but some people probably
> don't care enough. Also, making this portable and robust for everyone
> to use, not just your local environment, is pretty tricky. See
> pg_upgrade test script, for a prominent example.
To my knowledge, no one has even really seriously tried to package it
yet and then told the tale of woe, and it was an especially
un-gratifying exercise for quite a while on account of multiple
postgreses not getting along on the same machine because of SysV
shmem.
The bar for testing is a lot different than pg_upgrade (where a
negative consequence is confusing and stressful downtime), and many
programs use fork/threads and multiple connections even in testing,
making its requirements different.
So consider me still skeptical given the current reasoning that unix
sockets can't be a good-or-better substitute, and especially
accounting for programs that need multiple backends.
--
fdr
From | Date | Subject | |
---|---|---|---|
Next Message | Alvaro Herrera | 2012-09-06 00:56:32 | Re: Draft release notes complete |
Previous Message | Heikki Linnakangas | 2012-09-05 23:45:50 | Re: Cascading replication on Windows bug |