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@xxxxxxxxxxxxxx [mailto:pgsql-performance-owner@xxxxxxxxxxxxxx] 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
