Re: Let's make PostgreSQL multi-threaded

Поиск
Список
Период
Сортировка
От Greg Stark
Тема Re: Let's make PostgreSQL multi-threaded
Дата
Msg-id CAM-w4HMvXmjz=6r7Yf0yxHX-mzy60DPqoVB8K1b7COEBJKiZLg@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Let's make PostgreSQL multi-threaded  (Andres Freund <andres@anarazel.de>)
Ответы Re: Let's make PostgreSQL multi-threaded  (Andres Freund <andres@anarazel.de>)
Список pgsql-hackers
On Wed, 7 Jun 2023 at 18:09, Andres Freund <andres@anarazel.de> wrote:
> Having the same memory mapping between threads makes allows the
> hardware to share the TLB (on x86 via process context identifiers), which
> isn't realistically possible with different processes.

As a matter of historical interest Solaris actually did implement this
across different processes. It was called by the somewhat unfortunate
name "Intimate Shared Memory". I don't think Linux ever implemented
anything like it but I'm not sure.

I think this was not so much about cache hit rate but about just sheer
wasted memory in page mappings. So I guess hugepages more or less
target the same issues. But I find it interesting that they were
already running into issues like this 20 years ago -- presumably those
issues have only grown.

-- 
greg



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

Предыдущее
От: Jan Wieck
Дата:
Сообщение: Re: Named Prepared statement problems and possible solutions
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Error in calculating length of encoded base64 string