Re: Let's make PostgreSQL multi-threaded

Поиск
Список
Период
Сортировка
От Pavel Stehule
Тема Re: Let's make PostgreSQL multi-threaded
Дата
Msg-id CAFj8pRALmSZ-qHJ2+f5z7ckH_+=CpkEAZYp0b_bUXfYMjhz0ig@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Let's make PostgreSQL multi-threaded  (Heikki Linnakangas <hlinnaka@iki.fi>)
Список 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 по дате отправления:

Предыдущее
От: Andrew Dunstan
Дата:
Сообщение: Re: Let's make PostgreSQL multi-threaded
Следующее
От: Peter Geoghegan
Дата:
Сообщение: Re: Cleaning up nbtree after logical decoding on standby work