Results 1 to 3 of 3
  1. #1
    Join Date
    Dec 2009

    Unanswered: Performance tuning for postgres


    I am performing a DB insertion and update for 3000+ records and while doing so i get CPU utilization
    to 100% with 67% of CPU used by postgres....

    I have also done optimization on queries too...

    Is there any way to optimized the CPU utilization for postgres....

    Help will be appreciated....



  2. #2
    Join Date
    Dec 2009
    The OS which i use is Windows XP Professional SP2 and with postgres 8.3.
    I require a way to tune the performance of postgres so that it doesn't hit CPU utilizaion to 100% while performing bulk insertion and update.

  3. #3
    Join Date
    Aug 2009
    Olympia, WA
    How many cores do you have, and why don't you want CPU util to go to 100%? This is a database we're talking about. It was designed to do what you ask it to do as fast as it can not to sip resources so it doesn't interrupt your minesweeper game.

    You can import 3000 records in a tiny fraction of a second using copy. So if the process is dragging on for long enough to be complaining about it, you really need to be asking what you are doing wrong with your process and not how to configure the server to use less resources.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts