Parallel inserts

From: Ivan Voras <ivoras(at)geri(dot)cc(dot)fer(dot)hr>
To: pgsql-performance(at)postgresql(dot)org
Subject: Parallel inserts
Date: 2008-02-08 20:59:33
Message-ID: foifrm$pq5$1@ger.gmane.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

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?

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Bruce Momjian 2008-02-09 04:19:13 Re: Parallel inserts
Previous Message Mark Wong 2008-02-08 20:16:19 Re: Benchmark Data requested