Re: Extremely high CPU usage when building tables

From: Rajesh Kumar Mallah <mallah(dot)rajesh(at)gmail(dot)com>
To: Deborah Fuentes <dfuentes(at)eldocomp(dot)com>
Cc: "pgsql-performance(at)postgresql(dot)org" <pgsql-performance(at)postgresql(dot)org>
Subject: Re: Extremely high CPU usage when building tables
Date: 2010-07-02 19:53:03
Message-ID: AANLkTikBU8wFul1aXWIgO3HYqKkS_yjxU1MIx0Ze5RuU@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Dear Deb,

i feel three distinct steps are present
1. CREATE TABLE
2. LOAding of data in tables
3. Creation of indexes

It is still not clear when you are seeing your system becoming unresponsive
to
other application. Is it during loading of data or creation of indexes?

1. can you give any idea about how much data you are loading ? rows count or
GB data etc
2. how many indexes are you creation ?

regds
Rajesh Kumar Mallah.

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Bruce Momjian 2010-07-02 20:53:44 Re: No hash join across partitioned tables?
Previous Message Rajesh Kumar Mallah 2010-07-02 19:22:33 Re: how to (temporarily) disable/minimize benefits of disk block cache or postgresql shared buffer