Insert performance

From: "hatman" <joel(dot)winteregg(at)gmail(dot)com>
To: pgsql-performance(at)postgresql(dot)org
Subject: Insert performance
Date: 2007-02-27 17:10:21
Message-ID: 1172596221.393824.41130@j27g2000cwj.googlegroups.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Dear all,

After many tests and doc reading, i finally try to get help from
you...

Here is my problem. With some heavy insert into a simple BD (one
table, no indexes) i can't get better perf than 8000 inserts/sec. I'm
testing it using a simple C software which use libpq and which use:
- Insert prepared statement (to avoid too many request parsing on the
server)
- transaction of 100000 inserts

My server which has the following config:
- 3G RAM
- Pentium D - 64 bits, 3Ghz
- database data on hardware raid 0 disks
- x_log (WAL logs) on an other single hard drive

The server only use 30% of the CPU, 10% of disk access and not much
RAM... So i'm wondering where could be the bottle neck and why i can't
get better performance ?
I really need to use inserts and i can't change it to use COPY...

Any advice is welcome. Sorry in advance for my bad understanding of
database !

Thanks in advance.

Regards,

Joël.W

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message mark 2007-02-27 17:25:23 Re: Opinions on Raid
Previous Message Jim C. Nasby 2007-02-27 17:06:13 Re: Dead Space Map version 2