X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 37EA614B281B for ; Tue, 10 Aug 2004 12:37:57 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 27846-06 for ; Tue, 10 Aug 2004 15:37:52 +0000 (GMT) Received: from outland.mohawksoft.com (unknown [64.46.156.80]) by svr1.postgresql.org (Postfix) with ESMTP id 92FF114B281A for ; Tue, 10 Aug 2004 12:37:47 -0300 (ADT) Received: (from mohawk@localhost) by outland.mohawksoft.com (8.11.6/8.11.6) id i7AFsSO09616; Tue, 10 Aug 2004 11:54:28 -0400 From: pgsql@mohawksoft.com X-Authentication-Warning: outland.mohawksoft.com: mohawk set sender to pgsql@mohawksoft.com using -f Received: from 64.119.142.34 (SquirrelMail authenticated user pgsql) by mail.mohawksoft.com with HTTP; Tue, 10 Aug 2004 11:54:28 -0400 (EDT) Message-ID: <15691.64.119.142.34.1092153268.squirrel@mail.mohawksoft.com> In-Reply-To: <6EE64EF3AB31D5448D0007DD34EEB3412A7446@Herge.rcsinc.local> References: <6EE64EF3AB31D5448D0007DD34EEB3412A7446@Herge.rcsinc.local> Date: Tue, 10 Aug 2004 11:54:28 -0400 (EDT) Subject: Re: [HACKERS] fsync vs open_sync To: "Merlin Moncure" Cc: pgsql-performance@postgresql.org User-Agent: SquirrelMail/1.4.2 MIME-Version: 1.0 Content-Type: text/plain;charset=iso-8859-1 Content-Transfer-Encoding: 8bit X-Priority: 3 Importance: Normal X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=1.1 tagged_above=0.0 required=5.0 tests=NO_REAL_NAME, PRIORITY_NO_NAME X-Spam-Level: * X-Archive-Number: 200408/126 X-Sequence-Number: 7762 >> Anyway, with fsync enabled using standard fsync(), I get roughly > 300-400 >> inserts per second. With fsync disabled, I get about 7000 inserts per >> second. When I re-enable fsync but use the open_sync option, I can get >> about 2500 inserts per second. > > You are getting 300-400 inserts/sec with fsync on? If you don't mind me > asking, what's your hardware? (also, have you checked fsync on #s with > the new bgwriter in 7.5?) > 300 inserts persecond with fsync on using fdatasync. 2500 inserts per second with fsync on using open_sync. [mwoodward@penguin-021 mwoodward]$ cat /proc/cpuinfo processor : 0 vendor_id : GenuineIntel cpu family : 15 model : 2 model name : Intel(R) Xeon(TM) CPU 2.40GHz stepping : 5 cpu MHz : 2399.373 cache size : 512 KB fdiv_bug : no hlt_bug : no f00f_bug : no coma_bug : no fpu : yes fpu_exception : yes cpuid level : 2 wp : yes flags : fpu vme de pse tsc msr pae mce cx8 apic sep mtrr pge mca cmov pat pse36 clflush dts acpi mmx fxsr sse sse2 ss ht tm pbe cid bogomips : 4784.12 Linux node1 2.4.25 #1 Mon Mar 22 13:33:41 EST 2004 i686 i686 i386 GNU/Linux ide2: BM-DMA at 0xc400-0xc407, BIOS settings: hde:pio, hdf:pio hde: Maxtor 6Y200P0, ATA DISK drive hde: attached ide-disk driver. hde: host protected area => 1 hde: 398297088 sectors (203928 MB) w/7936KiB Cache, CHS=24792/255/63, UDMA(100) PDC20268: IDE controller at PCI slot 06:05.0