Received: from boushi.arl.wustl.edu (arl.wustl.edu [128.252.153.107]) by hub.org (8.9.3/8.9.3) with ESMTP id GAA02803 for ; Tue, 8 Feb 2000 06:32:43 -0500 (EST) (envelope-from rod@arl.wustl.edu) Received: from gupt.arl.wustl.edu (gupt.arl.wustl.edu [128.252.153.146]) by boushi.arl.wustl.edu (8.9.1/8.9.1) with ESMTP id FAA27925 for ; Tue, 8 Feb 2000 05:32:39 -0600 (CST) From: Radhesh Mohandas Received: (from rod@localhost) by gupt.arl.wustl.edu (8.9.1/8.9.1) id FAA02018 for pgsql-sql@postgresql.org; Tue, 8 Feb 2000 05:32:38 -0600 (CST) Date: Tue, 8 Feb 2000 05:32:38 -0600 (CST) Message-Id: <200002081132.FAA02018@gupt.arl.wustl.edu> To: pgsql-sql@postgresql.org Subject: Efficiency hi, If I have a large set of updates to be made - which may take around 10 minutes will it be faster if I include them in a transaction block ? I assume that the updates will be written into the database only on commit hence I may be able to save some disk writes and speed up the total update time? All comments will be appreciated. -Radhesh