| From: | Slavisa Garic <Slavisa(dot)Garic(at)infotech(dot)monash(dot)edu(dot)au> |
|---|---|
| To: | Christopher Kings-Lynne <chriskl(at)familyhealth(dot)com(dot)au> |
| Cc: | Slavisa Garic <Slavisa(dot)Garic(at)infotech(dot)monash(dot)edu(dot)au>, pgsql-performance(at)postgresql(dot)org |
| Subject: | Re: COPY with INDEXES question |
| Date: | 2004-02-06 02:52:28 |
| Message-ID: | Pine.GSO.4.10.10402061351490.25207-100000@bruce.csse.monash.edu.au |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers pgsql-performance |
Thanks for the reply and thanks even more for the good one :).
Cheers,
Slavisa
On Fri, 6 Feb 2004, Christopher Kings-Lynne wrote:
> > I have a quick question. In order to speed up insertion of large number of
> > rows (100s of thousands) I replaced the INSERT with the COPY. This works
> > fine but one question popped into my mind. Does copy updates indexes on
> > that table if there are some defined?
>
> Yes, of course. Runs triggers and stuff as well.
>
> Chris
>
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Christopher Kings-Lynne | 2004-02-06 02:54:12 | Re: COPY with INDEXES question |
| Previous Message | Christopher Kings-Lynne | 2004-02-06 01:11:25 | Re: It's past time to redo the smgr API |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Christopher Kings-Lynne | 2004-02-06 02:54:12 | Re: COPY with INDEXES question |
| Previous Message | Slavisa Garic | 2004-02-06 00:46:57 | COPY with INDEXES question |