Received: from maia.hub.org (maia-5.hub.org [200.46.204.29]) by mail.postgresql.org (Postfix) with ESMTP id 91001633380 for ; Tue, 6 Jul 2010 12:59:51 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.29]) (amavisd-maia, port 10024) with ESMTP id 99157-06 for ; Tue, 6 Jul 2010 15:59:42 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from exchange.eldocomp.com (winex2.eldocomp.com [205.159.99.53]) by mail.postgresql.org (Postfix) with ESMTP id 85E85633337 for ; Tue, 6 Jul 2010 12:59:42 -0300 (ADT) Received: from WINEX1.eldocomp.com ([fe80::4020:f5e6:ce9:1af]) by winex2.eldocomp.com ([::1]) with mapi; Tue, 6 Jul 2010 08:59:23 -0700 From: Deborah Fuentes To: Rajesh Kumar Mallah CC: "pgsql-performance@postgresql.org" Subject: Re: Extremely high CPU usage when building tables Thread-Topic: [PERFORM] Extremely high CPU usage when building tables Thread-Index: AQHLGQLRGTrTZy2kS06hwn0kFlKdupKeAQNwgACCrICABY6lsA== Date: Tue, 6 Jul 2010 15:59:23 +0000 Message-ID: <306A7ABFF569E847BC99BA08C183EFF3014205@WINEX1.eldocomp.com> References: <306A7ABFF569E847BC99BA08C183EFF3ED95@WINEX1.eldocomp.com> <306A7ABFF569E847BC99BA08C183EFF3013645@WINEX1.eldocomp.com> In-Reply-To: Accept-Language: en-US Content-Language: en-US X-MS-Has-Attach: X-MS-TNEF-Correlator: Content-Type: multipart/alternative; boundary="_000_306A7ABFF569E847BC99BA08C183EFF3014205WINEX1eldocompcom_" MIME-Version: 1.0 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.791 tagged_above=-10 required=5 tests=BAYES_50=0.8, HTML_MESSAGE=0.001, T_RP_MATCHES_RCVD=-0.01 X-Spam-Level: X-Archive-Number: 201007/60 X-Sequence-Number: 39449 --_000_306A7ABFF569E847BC99BA08C183EFF3014205WINEX1eldocompcom_ Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable Rajesh, We are not loading any data. There are only two steps present: 1. Create tables - 1127 2. Create indexes - approximately 7000 The CPU spikes immediately when the tables are being created. Regards, Deb From: Rajesh Kumar Mallah [mailto:mallah.rajesh@gmail.com] Sent: Friday, July 02, 2010 12:53 PM To: Deborah Fuentes Cc: pgsql-performance@postgresql.org Subject: Re: [PERFORM] Extremely high CPU usage when building tables 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 o= r GB data etc 2. how many indexes are you creation ? regds Rajesh Kumar Mallah. --_000_306A7ABFF569E847BC99BA08C183EFF3014205WINEX1eldocompcom_ Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable

Rajesh,

 

We are not loading any data. There are only two steps presen= t:

 

1.&n= bsp;      Create tables –  1127

2.&n= bsp;      Create indexes – approximately 7000<= /p>

 

The CPU spikes immediately when the tables are being created= .

 

Regards,

Deb

 

From: Rajesh Kumar = Mallah [mailto:mallah.rajesh@gmail.com]
Sent: Friday, July 02, 2010 12:53 PM
To: Deborah Fuentes
Cc: pgsql-performance@postgresql.org
Subject: Re: [PERFORM] Extremely high CPU usage when building tables=

 

 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 o= r GB data etc
2. how many indexes are you creation ?

regds
Rajesh Kumar Mallah.

--_000_306A7ABFF569E847BC99BA08C183EFF3014205WINEX1eldocompcom_--