Re: Let's make PostgreSQL multi-threaded - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Let's make PostgreSQL multi-threaded
Date
Msg-id 4178104.1685978307@sss.pgh.pa.us
Whole thread Raw
In response to Let's make PostgreSQL multi-threaded  (Heikki Linnakangas <hlinnaka@iki.fi>)
Responses Re: Let's make PostgreSQL multi-threaded
Re: Let's make PostgreSQL multi-threaded
Re: Let's make PostgreSQL multi-threaded
Re: Let's make PostgreSQL multi-threaded
List pgsql-hackers
Heikki Linnakangas <hlinnaka@iki.fi> writes:
> I spoke with some folks at PGCon about making PostgreSQL multi-threaded, 
> so that the whole server runs in a single process, with multiple 
> threads. It has been discussed many times in the past, last thread on 
> pgsql-hackers was back in 2017 when Konstantin made some experiments [0].

> I feel that there is now pretty strong consensus that it would be a good 
> thing, more so than before. Lots of work to get there, and lots of 
> details to be hashed out, but no objections to the idea at a high level.

> The purpose of this email is to make that silent consensus explicit. If 
> you have objections to switching from the current multi-process 
> architecture to a single-process, multi-threaded architecture, please 
> speak up.

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.

            regards, tom lane



pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: QUAL Pushdown causes ERROR on syntactically and semantically correct SQL Query
Next
From: Kirk Wolak
Date:
Subject: Re: [BUG] pg_dump does not properly deal with BEGIN ATOMIC function