Received: from magus.postgresql.org (magus.postgresql.org [87.238.57.229]) by mail.postgresql.org (Postfix) with ESMTP id C4B2A3F2E7B for ; Fri, 25 May 2012 19:05:33 -0300 (ADT) Received: from plane.gmane.org ([80.91.229.3]) by magus.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1SY2dW-00036i-Ay for pgsql-performance@postgresql.org; Fri, 25 May 2012 22:05:31 +0000 Received: from list by plane.gmane.org with local (Exim 4.69) (envelope-from ) id 1SY2dI-0001Or-5U for pgsql-performance@postgresql.org; Sat, 26 May 2012 00:05:16 +0200 Received: from cpe-188-129-85-71.dynamic.amis.hr ([188.129.85.71]) by main.gmane.org with esmtp (Gmexim 0.1 (Debian)) id 1AlnuQ-0007hv-00 for ; Sat, 26 May 2012 00:05:16 +0200 Received: from ivoras by cpe-188-129-85-71.dynamic.amis.hr with local (Gmexim 0.1 (Debian)) id 1AlnuQ-0007hv-00 for ; Sat, 26 May 2012 00:05:16 +0200 X-Injected-Via-Gmane: http://gmane.org/ To: pgsql-performance@postgresql.org From: Ivan Voras Subject: Parallel (concurrent) inserts? Date: Sat, 26 May 2012 00:04:58 +0200 Lines: 17 Message-ID: Mime-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit X-Complaints-To: usenet@dough.gmane.org X-Gmane-NNTP-Posting-Host: cpe-188-129-85-71.dynamic.amis.hr User-Agent: Mozilla/5.0 (Windows NT 6.1; WOW64; rv:12.0) Gecko/20120428 Thunderbird/12.0.1 X-Pg-Spam-Score: -1.9 (-) X-Archive-Number: 201205/149 X-Sequence-Number: 46973 Hello, I'm wondering if there is ia document describing which guarantees (if any) PostgreSQL makes about concurrency for various operations? Speaking in general (i.e. IO can handle it, number of CPU cores and client threads is optimal), are fully concurrent operations (independant and non-blocking) possible for: 1) An unindexed table? 2) A table with 1+ ordinary (default btree) indexes? (are there constraints on the structure and number of indexes?) 3) A table with 1+ unique indexes? 4) A table with other objects on it (foreign keys, check constraints, etc.)?