Hi, Jim,
Jim Nasby wrote:
Your biggest win would be to batch those inserts together into
transactions, if possible.
Using COPY instead of INSERT might even give better wins, and AFAIK some
client libs use COPY internally (e. G. tablewriter from libpqxx).
If not, the commit_delay settings
Please cc the list so others can help.
How large is the database? What indexes are on the tables you're inserting
into? What speed is the drive?
Since it's a single SCSI drive I'm assuming it's only 10k RPM, which means the
theoretical maximum you can hit is 160 transfers per second. At 40
This isn't a bug; moving to pgsql-performance.
On Tue, Aug 08, 2006 at 08:42:02AM +, kumarselvan wrote:
i have installed the postgres as mentioned in the Install file. it is a 4
cpu 8 GB Ram Machine installed with Linux Enterprise version 3. when i am
running a load which will perfrom 40