: 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
0 100
c3t60A98000572D4275684A56385468434Fd0
Thanks!
Deb
From: Rajesh Kumar Mallah [mailto:mallah.raj...@gmail.com]
Sent: Thursday, July 01, 2010 2:50 AM
To: Deborah Fuentes
Cc: pgsql-performance@postgresql.org
Subject: Re: [PERFORM] Extremely high CPU usage when building tables
Hi,
1. Did you also
Hello,
When I run an SQL to create new tables and indexes is when Postgres consumes
all CPU and impacts other users on the server.
We are running Postgres 8.3.7 on a Sun M5000 with 2 x quad core CPUs (16
threads) running Solaris 10.
I've attached the sar data at the time of the run- here's a s
