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.raj...@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 or GB data etc 2. how many indexes are you creation ? regds Rajesh Kumar Mallah.