Postgres Pro
Downloads
Home   >   mailing lists

Re: Extremely high CPU usage when building tables - Mailing list pgsql-performance

From Rajesh Kumar Mallah
Subject Re: Extremely high CPU usage when building tables
Date
Msg-id AANLkTikBU8wFul1aXWIgO3HYqKkS_yjxU1MIx0Ze5RuU@mail.gmail.com
Whole thread Raw
In response to Extremely high CPU usage when building tables  (Deborah Fuentes <dfuentes@eldocomp.com>)
Responses Re: Extremely high CPU usage when building tables
List pgsql-performance
Tree view
 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.
#avg_ls_inline_popup { position:absolute; z-index:9999; padding: 0px 0px; margin-left: 0px; margin-top: 0px; width: 240px; overflow: hidden; word-wrap: break-word; color: black; font-size: 10px; text-align: left; line-height: 13px;}

pgsql-performance by date:

Previous
From: Rajesh Kumar Mallah
Date:
Subject: Re: how to (temporarily) disable/minimize benefits of disk block cache or postgresql shared buffer
Next
From: Bruce Momjian
Date:
Subject: Re: No hash join across partitioned tables?