Merlin Moncure wrote:

I'm running postgresl 9.0. After partitioning a big table, CPU
usage raised from average 5-10% to average 70-80%.
First thing that jumps to mind is you have some seq-scan heavy
plans that were not seq-scan before.
Make sure that all indexes are defined for each partition. It is
not enough to define them on just the parent level.

-Kevin

Search Discussions

Discussion Posts

Previous

Follow ups

Related Discussions

Discussion Navigation
viewthread | post
posts ‹ prev | 6 of 14 | next ›
Discussion Overview
grouppgsql-performance @
categoriespostgresql
postedJan 21, '13 at 3:05p
activeJan 22, '13 at 6:38p
posts14
users9
websitepostgresql.org
irc#postgresql

People

Translate

site design / logo © 2021 Grokbase