Re: Proof of concept: standalone backend with full FE/BE protocol

Josh Berkus <josh@agliodbs.com> wrote:
 
> In fact, most of the folks who would want an embedded PostgreSQL
> either want no authentication at all, or only a single password. 
> So supporting authentication options other than trust or md5 is
> not required, or desired AFAIK.
 
I don't know whether it's worth the trouble of doing so, but
serializable transactions could skip all the SSI predicate locking
and conflict checking when in single-connection mode.  With only one
connection the transactions could never overlap, so there would be
no chance of serialization anomalies when running snapshot
isolation.
 
The reason I wonder whether it is worth the trouble is that it would
only really matter if someone had code they wanted to run under both
normal and single-connection modes.  For single-connection only,
they could just choose REPEATABLE READ to get exactly the same
semantics.
 
-Kevin