Re: Let's make PostgreSQL multi-threaded

Поиск
Список
Период
Сортировка
От Jonah H. Harris
Тема Re: Let's make PostgreSQL multi-threaded
Дата
Msg-id CADUqk8UyyiLsVSFB+6LYwvRos123-333YT5d3eZ-eUBvXVyDBQ@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Let's make PostgreSQL multi-threaded  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: Let's make PostgreSQL multi-threaded  (Jeremy Schneider <schneider@ardentperf.com>)
Re: Let's make PostgreSQL multi-threaded  (Konstantin Knizhnik <knizhnik@garret.ru>)
Список pgsql-hackers
On Mon, Jun 5, 2023 at 8:18 AM Tom Lane <tgl@sss.pgh.pa.us> wrote:
For the record, I think this will be a disaster.  There is far too much
code that will get broken, largely silently, and much of it is not
under our control.

While I've long been in favor of a multi-threaded implementation, now in my old age, I tend to agree with Tom. I'd be interested in Konstantin's thoughts (and PostgresPro's experience) of multi-threaded vs. internal pooling with the current process-based model. I recall looking at and playing with Konstantin's implementations of both, which were impressive. Yes, the latter doesn't solve the same issues, but many real-world ones where multi-threaded is argued. Personally, I think there would be not only a significant amount of time spent dealing with in-the-field stability regressions before a multi-threaded implementation matures, but it would also increase the learning curve for anyone trying to start with internals development.

--
Jonah H. Harris

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

Предыдущее
От: Gurjeet Singh
Дата:
Сообщение: Re: Mark a transaction uncommittable
Следующее
От: "Daniel Verite"
Дата:
Сообщение: Inconsistent results with libc sorting on Windows