Received: from inje.iskon.hr (root@inje.iskon.hr [213.191.128.16]) by hub.org (8.10.1/8.10.1) with ESMTP id e7UN8bC79311 for ; Wed, 30 Aug 2000 19:08:38 -0400 (EDT) Received: from atlas.iskon.hr (atlas.iskon.hr [213.191.131.6]) by inje.iskon.hr (8.9.3/8.9.3/Debian 8.9.3-6) with ESMTP id BAA00957; Thu, 31 Aug 2000 01:08:27 +0200 Received: (from zcalusic@localhost) by atlas.iskon.hr (8.11.0/8.11.0/Debian 8.11.0-1) id e7UMDJH00428; Thu, 31 Aug 2000 00:13:19 +0200 To: Jie Liang Cc: Stephan Szabo , pgsql-sql@postgresql.org Subject: Re: Optimizing huge inserts/copy's References: <39AD34BE.74717395@ipinc.com> Reply-To: zlatko@iskon.hr X-Face: s71Vs\G4I3mB$X2=P4h[aszUL\%"`1!YRYl[JGlC57kU-`kxADX}T/Bq)Q9.$fGh7lFNb.s i&L3xVb:q_Pr}>Eo(@kU, c:3:64cR]m@27>1tGl1):#(bs*Ip0c}N{:JGcgOXd9H'Nwm:}jLr\FZtZ pri/C@\,4lW<|jrq^<):Nk%Hp@G&F"r+n1@BoH From: Zlatko Calusic Date: 31 Aug 2000 00:13:18 +0200 In-Reply-To: Jie Liang's message of "Wed, 30 Aug 2000 09:22:22 -0700" Message-ID: <87pumqxurl.fsf@atlas.iskon.hr> Lines: 23 User-Agent: Gnus/5.0808 (Gnus v5.8.8) XEmacs/21.2 (Nike) MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Archive-Number: 200008/356 Jie Liang writes: > Hi, there, > > I tried different ways, include vaccum table , ensure index works, it > still is as slow as ~100rows per minute. > PGFSYNC=no in postmaster.init? Well, this might be Debian Linux specific, pardon me if it is. I have just begun playing with Postgres. Still learning, myself. IOW, disable fsync after every statement and your OS will do much better work clustering writes. That means more inserts/sec for you. In one of my tests I was able to insert at ~1000/sec rate. Then I made an experiment, enabled pgfsync _and_ indexes. The inserting speed dropped to 10/sec. Very interesting. Regards, -- Zlatko