Received: from localhost (unknown [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id 016D82E2E85 for ; Fri, 8 Feb 2008 18:50:14 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024) with ESMTP id 38459-05 for ; Fri, 8 Feb 2008 18:50:03 -0400 (AST) Received: from ciao.gmane.org (main.gmane.org [80.91.229.2]) by postgresql.org (Postfix) with ESMTP id 776EE2E2DBF for ; Fri, 8 Feb 2008 18:50:08 -0400 (AST) Received: from root by ciao.gmane.org with local (Exim 4.43) id 1JNc2k-0003Wr-Qv for pgsql-performance@postgresql.org; Fri, 08 Feb 2008 22:50:02 +0000 Received: from 78-0-94-116.adsl.net.t-com.hr ([78.0.94.116]) by main.gmane.org with esmtp (Gmexim 0.1 (Debian)) id 1AlnuQ-0007hv-00 for ; Fri, 08 Feb 2008 22:50:02 +0000 Received: from ivoras by 78-0-94-116.adsl.net.t-com.hr with local (Gmexim 0.1 (Debian)) id 1AlnuQ-0007hv-00 for ; Fri, 08 Feb 2008 22:50:02 +0000 X-Injected-Via-Gmane: http://gmane.org/ To: pgsql-performance@postgresql.org From: Ivan Voras Subject: Parallel inserts Date: Fri, 08 Feb 2008 21:59:33 +0100 Lines: 7 Message-ID: Mime-Version: 1.0 Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 7bit X-Complaints-To: usenet@ger.gmane.org X-Gmane-NNTP-Posting-Host: 78-0-94-116.adsl.net.t-com.hr User-Agent: Thunderbird 2.0.0.9 (Windows/20071031) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.001 tagged_above=0 required=5 tests=BAYES_50=0.001 X-Spam-Level: X-Archive-Number: 200802/94 X-Sequence-Number: 28636 Hi, Assuming two or more clients issue INSERTs and COPYs on the same table in the database at the same time, does PostgreSQL execute them in parallel (i.e. no table-level locks, etc.) assuming there are no indexes and constrains on the table? What about when there are indexes and/or constraints?