Обсуждение: Parallel inserts

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?

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. +