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
