Re: High CPU usage after partitioning

From: "Kevin Grittner" <kgrittn(at)mail(dot)com>
To: "Merlin Moncure" <mmoncure(at)gmail(dot)com>,"rudi" <rudolone(at)gmail(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: High CPU usage after partitioning
Date: 2013-01-21 21:12:14
Message-ID: 20130121211214.120610@gmx.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

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

Browse pgsql-performance by date

  From Date Subject
Next Message Andrew Dunstan 2013-01-22 00:41:29 Re: High CPU usage after partitioning
Previous Message Merlin Moncure 2013-01-21 17:13:31 Re: High CPU usage after partitioning