pg.ddx.io pgsql-performance@postgresql.org mailing list archive
help / color / mirror / Atom feedParallel inserts
2+ messages / 2 participants
[nested] [flat]
* Parallel inserts
@ 2008-02-08 20:59 Ivan Voras <ivoras@geri.cc.fer.hr>
2008-02-09 04:19 ` Re: Parallel inserts Bruce Momjian <bruce@momjian.us>
0 siblings, 1 reply; 2+ messages in thread
From: Ivan Voras @ 2008-02-08 20:59 UTC (permalink / raw)
To: 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?
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: Parallel inserts
2008-02-08 20:59 Parallel inserts Ivan Voras <ivoras@geri.cc.fer.hr>
@ 2008-02-09 04:19 ` Bruce Momjian <bruce@momjian.us>
0 siblings, 0 replies; 2+ messages in thread
From: Bruce Momjian @ 2008-02-09 04:19 UTC (permalink / raw)
To: Ivan Voras <ivoras@geri.cc.fer.hr>; +Cc: 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. +
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2008-02-09 04:19 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2008-02-08 20:59 Parallel inserts Ivan Voras <ivoras@geri.cc.fer.hr>
2008-02-09 04:19 ` Bruce Momjian <bruce@momjian.us>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox