Re: Performace Optimization for Dummies

From: "Carlo Stonebanks" <stonec(dot)register(at)sympatico(dot)ca>
To: pgsql-performance(at)postgresql(dot)org
Subject: Re: Performace Optimization for Dummies
Date: 2006-10-03 03:01:50
Message-ID: efsjqt$1elv$1@news.hub.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

> 1. fork your import somhow to get all 4 cores running

This is already happening, albeit only 3. No improvement - it appears we
have taken the same problem, and divided it by 3. Same projected completion
time. this is really curious, to say the least.

> 2. write the code that actually does the insert in C and use the
> parameterized prepared statement.

I had already tried the paremetrised prepare statement; I had mentioned that
I was surprised that it had no effect. No one here seemed surprised, or at
least didn't think of commenting on it.

> however, your general approach has been 'please give me advice, but
> only the advice that i want'.

I'm sorry I don't understand - I had actually originally come asking four
questions asking for recommendations and opinions on hardware, O/S and
commercial support. I did also ask for comments on my config setup.

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Carlo Stonebanks 2006-10-03 03:03:31 Re: Performace Optimization for Dummies
Previous Message Carlo Stonebanks 2006-10-03 03:01:04 Re: Performace Optimization for Dummies