Re: Parallel inserts - Mailing list pgsql-performance

From Bruce Momjian
Subject Re: Parallel inserts
Date
Msg-id 200802090419.m194JD911274@momjian.us
Whole thread Raw
In response to Parallel inserts  (Ivan Voras <ivoras@geri.cc.fer.hr>)
List pgsql-performance
Ivan Voras wrote:
> 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?

Yes, parallel in all cases.

--
  Bruce Momjian  <bruce@momjian.us>        http://momjian.us
  EnterpriseDB                             http://postgres.enterprisedb.com

  + If your life is a hard drive, Christ can be your backup. +

pgsql-performance by date:

Previous
From: Ivan Voras
Date:
Subject: Parallel inserts
Next
From: Simon Riggs
Date:
Subject: Re: Optimizer : query rewrite and execution plan ?