Postgres Pro
Downloads
Home   >   mailing lists

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

From Kevin Grittner
Subject Re: Extremely high CPU usage when building tables
Date
Msg-id 4C3324F10200002500033033@gw.wicourts.gov
Whole thread Raw
In response to Re: Extremely high CPU usage when building tables  (Deborah Fuentes <dfuentes@eldocomp.com>)
List pgsql-performance
Tree view 
Deborah Fuentes <dfuentes@eldocomp.com> wrote:

> 1.       Create tables -  1127
>
> 2.       Create indexes - approximately 7000

What does your postgresql.conf look like (excluding all comments)?

How many connections are you using to create these tables and indexes?

What else is running on the machine?

-Kevin

pgsql-performance by date:

Previous
From: Deborah Fuentes
Date:
Subject: Re: Extremely high CPU usage when building tables
Next
From: Robert Haas
Date:
Subject: Re: Highly Efficient Custom Sorting