Re: Postgresql 14 performance

Поиск
Список
Период
Сортировка
От Kenny Bachman
Тема Re: Postgresql 14 performance
Дата
Msg-id CAC0w7L+GFza2xyAt-4SQwsMbQWAUqCf7tp+k5gOQZ6hwknDh3w@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Postgresql 14 performance  (Mladen Gogala <gogala.mladen@gmail.com>)
Ответы Re: Postgresql 14 performance
Список pgsql-admin
The huge_pages parameter is try. How can I know the huge page is used for shared buffers?
Also, I would like to say one more thing. Some queries have high planning time of explain analyze output. However, I run vacuumdb analyze command every day. I am a little bit confused about this.

Warm regards,
Kenn

Mladen Gogala <gogala.mladen@gmail.com>, 22 Ağu 2022 Pzt, 15:56 tarihinde şunu yazdı:
On 8/21/22 21:16, Mladen Gogala wrote:

Agreed. The "perf top" output produced by Kenny definitely indicates that. That's precisely why I concentrated on JIT. Anything else would give us a slim chance of increasing the query speed.

When I come to think of it, are you using huge pages for shared buffers? Huge pages tend to decrease page tables and lessen the impact of paging.

Regards

-- 
Mladen Gogala
Database Consultant
Tel: (347) 321-1217
https://dbwhisperer.wordpress.com

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

Предыдущее
От: Mladen Gogala
Дата:
Сообщение: Re: Postgresql 14 performance
Следующее
От: Sbob
Дата:
Сообщение: DB Encoding question