Robert Haas <robertmhaas(at)gmail(dot)com> wrote:
> Jeff Janes <jeff(dot)janes(at)gmail(dot)com> wrote:
>> Oracle's backend start up time seems to be way higher than PG's.
> Interesting. How about MySQL and SQL Server?
My recollection of Sybase ASE is that establishing a connection
doesn't start a backend or even a thread. It establishes a network
connection and associates network queues and a connection context
structure with it. "Engine" threads with CPU affinity (and a few
miscellaneous "worker" threads, too, if I remember right) do all the
work in a queue-based fashion.
Last I worked with MS SQL Server it was based on the Sybase code and
therefore worked the same way. I know they've made a lot of changes
in the last five years (including switching to MVCC and adding
snapshot isolation in addition to the already-existing serializable
isolation), so I don't know whether connection startup cost has
changed along the way.
In response to
pgsql-hackers by date
|Next:||From: Tom Lane||Date: 2010-12-01 15:36:50|
|Subject: Re: KNNGIST next step: adjusting indexAM API |
|Previous:||From: Dimitri Fontaine||Date: 2010-12-01 15:24:17|
|Subject: Re: KNNGIST next step: adjusting indexAM API|