Re: Urgent: 10K or more connections

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Urgent: 10K or more connections
Дата
Msg-id 18351.1058673380@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Urgent: 10K or more connections  (Sean Chittenden <sean@chittenden.org>)
Список pgsql-general
Sean Chittenden <sean@chittenden.org> writes:
> No where, everything remains as is.  I actually think you'll
> appreciate the simplicity of this once I'm done explaining how I'm
> going about this.

I don't think you heard a word I said :-(

You appear to be adding a whole lot of platform dependency (passing
FDs around other than by fork() is not portable) in return for loss
of functionality (applications can't rely on session state anymore)
and highly dubious performance gain (just because a backend has started
does not mean it's built up a reasonable working set of cache entries;
you can't expect that firing off a new backend for every transaction
is going to be anything but a huge performance loss, even if you assume
its visible session state is exactly what the application needs).

Also it sounds to me like the postmaster will now become a performance
bottleneck, since it will need to be involved in every transaction start.

You're welcome to pursue this if you like, but I'll bet lunch that
you are wasting your time.

            regards, tom lane

В списке pgsql-general по дате отправления:

Предыдущее
От: "Peter Galbavy"
Дата:
Сообщение: Re: [pgsql-advocacy] MySQL gets $19.5 MM
Следующее
От: elein
Дата:
Сообщение: Re: Fw: Is SQL silly as an RDBMS<->app interface?