Re: Postgres refusing to use >1 core

Поиск
Список
Период
Сортировка
От Aren Cambre
Тема Re: Postgres refusing to use >1 core
Дата
Msg-id BANLkTim=3U4q7MEHfF4uyWCwR4H0b-P0rA@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Postgres refusing to use >1 core  (Craig Ringer <craig@postnewspapers.com.au>)
Список pgsql-performance
It's always good to hear when these things work out. Thanks for
reporting back.

Using the set-based nature of relational databases to your advantage,
writing smarter queries that do more work server-side with fewer
round-trips, and effective batching can make a huge difference.

Glad I could be a good digital citizen! :-)

Correction: it's going to run for significantly more than 2 hours, but far less than 30 hours!

I'm loving seeing the CPU meter showing all 8 of my (fake) cores being pounded mercilessly!

Aren

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

Предыдущее
От: Shaun Thomas
Дата:
Сообщение: Re: Performance degradation of inserts when database size grows
Следующее
От: Dave Johansen
Дата:
Сообщение: Re: Pushing LIMIT into sub-queries of a UNION ALL?