Re: Sample rate added to pg_stat_statements

Поиск
Список
Период
Сортировка
От Sami Imseih
Тема Re: Sample rate added to pg_stat_statements
Дата
Msg-id CAA5RZ0uKAm0sxcU40R+G9mb8g=jBC5bmj4zLmSyTz40vJEF3SA@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Sample rate added to pg_stat_statements  (Ilia Evdokimov <ilya.evdokimov@tantorlabs.com>)
Список pgsql-hackers
> and we've been trying to solve a non-existent problem?

Anecdotally speaking, Most users will encounter bottlenecks
due to exclusive locks on pgss hash ( dealloc and garbage collection )
more often than they will on the spinlock. The spinlock will likely
become more of an issue when you are not seeing much dealloc/gc
and running on a very large machine. So, I don't think it's a non-existent
problem, but I don't think it's the most common problem.

Regards,

Sami



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