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

From Pavel Stehule
Subject Re: Let's make PostgreSQL multi-threaded
Date
Msg-id CAFj8pRALmSZ-qHJ2+f5z7ckH_+=CpkEAZYp0b_bUXfYMjhz0ig@mail.gmail.com
Whole thread Raw
In response to Re: Let's make PostgreSQL multi-threaded  (Heikki Linnakangas <hlinnaka@iki.fi>)
List pgsql-hackers
Hi

In the long run, a single-process architecture makes it easier to have
shared catalog caches, plan cache, etc. which can improve performance.
And it can make it easier to launch helper threads for things where
worker processes would be too heavy-weight. But those benefits will
require more work, they won't happen just by replacing processes with
threads.

The shared plan cache is not a silver bullet. The good management of shared plan cache is very very difficult. Our heuristic about custom plans in prepared statements is nothing, and you should reduce the usage of custom plans too.

There are a lot of issues known from Oracle. The benefits can be just for very primitive very fast queries, or extra complex queries where generic plan is used.  Current implementation of local plan caches has lot of issues (that cannot be fixed), but shared plan cache is another level of complexity

Regards

Pavel




pgsql-hackers by date:

Previous
From: Andrew Dunstan
Date:
Subject: Re: Let's make PostgreSQL multi-threaded
Next
From: Peter Geoghegan
Date:
Subject: Re: Cleaning up nbtree after logical decoding on standby work