Re:

Forgot to reply to the mailing list..... Sorry (new here)
Here are responses to previous questions....

-----Original Message-----
From: Orhan Aglagul
Sent: Tuesday, May 08, 2007 5:30 PM
To: 'Joshua D. Drake'
Subject: RE: [PERFORM]

I am using a prepared statement and inserting in a loop 10,000 records.
I need the data real time, so I am not using batch inserts. I have to
run each insert as a separate transaction....
I am running the app on a RH EL4 (Kernel 2.6.20).
In fact my CPU usage is too low when running the app with fsync=off.

Here is the output of vmstat during the test:
First 10 lines:

r b swpd free buff cache si so bi bo in cs us sy
id wa
0 1 0 1634144 21828 234752 0 0 32 408 210 404 0 0
90 9
0 1 0 1634020 21828 234816 0 0 0 1404 538 1879 0 0
50 50
0 1 0 1633896 21828 234940 0 0 0 1400 525 1849 0 0
50 49
0 1 0 1633772 21828 235048 0 0 0 1412 537 1878 0 0
50 50
0 1 0 1633648 21832 235168 0 0 0 1420 531 1879 0 0
50 50
0 1 0 1633524 21840 235280 0 0 0 1420 535 1884 0 0
50 50
0 1 0 1633524 21844 235400 0 0 0 1396 535 1718 0 0
50 50
0 1 0 1633524 21848 235524 0 0 0 1536 561 1127 0 0
50 50
0 1 0 1633524 21852 235644 0 0 0 1412 557 1390 0 0
50 50
0 1 0 1633268 21860 235728 0 0 0 1408 582 1393 0 0
50 50
0 1 0 1633268 21868 235844 0 0 0 1424 548 1377 1 4
50 45
1 0 0 1633144 21876 235968 0 0 0 1404 548 1394 14 4
48 34
0 1 0 1633020 21884 236084 0 0 0 1420 540 1374 5 0
50 46
...

The logical volume is an ext3 file system. That's where all the database
files reside. (No hardware optimization done).

Sorry for the delay,
Thanks..

-----Original Message-----
From: pgsql-performance-owner(at)postgresql(dot)org
[mailto:pgsql-performance-owner(at)postgresql(dot)org] On Behalf Of Joshua D.
Drake
Sent: Tuesday, May 08, 2007 5:05 PM
To: Dan Harris
Cc: PostgreSQL Performance
Subject: Re: [PERFORM]

Dan Harris wrote:
> Orhan Aglagul wrote:
>> Hi Everybody,
>>
>> I was trying to see how many inserts per seconds my application could

>> handle on various machines.
>>
>>
>> I read that postgres does have issues with MP Xeon (costly context
>> switching). But I still think that with fsync=on 65 seconds is
>> ridiculous.
>
> CPU is unlikely your bottleneck.. You failed to mention anything
about
> your I/O setup. More details in this regard will net you better
> responses. However, an archive search for insert performance will
> probably be worthwhile, since this type of question is repeated about
> once a month.

He also fails to mention if he is doing the inserts one at a time or as
batch.

Joshua D. Drake

>
>
>
>
> ---------------------------(end of
broadcast)---------------------------
> TIP 2: Don't 'kill -9' the postmaster
>

--

=== The PostgreSQL Company: Command Prompt, Inc. ===
Sales/Support: +1.503.667.4564 || 24x7/Emergency: +1.800.492.2240
Providing the most comprehensive PostgreSQL solutions since 1997
http://www.commandprompt.com/

Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate
PostgreSQL Replication: http://www.commandprompt.com/products/

---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?

http://archives.postgresql.org