Re: Postgresql 14 performance
| От | Mladen Gogala |
|---|---|
| Тема | Re: Postgresql 14 performance |
| Дата | |
| Msg-id | d8df81e2-c844-d7f5-f1e6-7c050ecaa4c2@gmail.com обсуждение исходный текст |
| Ответ на | Re: Postgresql 14 performance (Jeff Janes <jeff.janes@gmail.com>) |
| Ответы |
Re: Postgresql 14 performance
Re: Postgresql 14 performance |
| Список | pgsql-admin |
On 8/21/22 20:46, Jeff Janes wrote:
You can see there that little time was spent reading data, so that explains why repeating the query didn't make it much faster due to caching. The time isn't spent reading data, but doing CPU work on data already in memory.Cheers,Jeff
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.
Regards
-- Mladen Gogala Database Consultant Tel: (347) 321-1217 https://dbwhisperer.wordpress.com
В списке pgsql-admin по дате отправления: