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@postgresql.org
[mailto:pgsql-performance-owner@postgresql.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