Re: questions on (parallel) COPY and when to REINDEX

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Andy Colson <andy(at)squeakycode(dot)net>
Cc: Janet Jacobsen <jsjacobsen(at)lbl(dot)gov>, pgsql-general(at)postgresql(dot)org
Subject: Re: questions on (parallel) COPY and when to REINDEX
Date: 2009-08-02 04:55:08
Message-ID: 18890.1249188908@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Andy Colson <andy(at)squeakycode(dot)net> writes:
> I have never tried two processes copy'ing into the same table at the same time, but I'd bet its possible.

It's no different from concurrent INSERTs ...

regards, tom lane

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Jun Yang 2009-08-02 05:09:59 Re: Can I add a super table to existing tables?
Previous Message David Fetter 2009-08-02 04:42:25 Re: Can I add a super table to existing tables?