| From: | Wim <wdh(at)belbone(dot)be> |
|---|---|
| To: | Colin Gillespie <C(dot)Gillespie(at)newcastle(dot)ac(dot)uk> |
| Cc: | pgsql-novice(at)postgresql(dot)org |
| Subject: | Re: INSERT or COPY: Which one? |
| Date: | 2004-02-18 07:58:28 |
| Message-ID: | Pine.LNX.4.53.0402180857160.5928@tyr.car.belbone.be |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-novice |
Hi Colin,
COPY is much faster that INSERT, although INSERT is safer. I think that
you can speed up the INSERT by disabling autocommit...
Cheers!
Wim
On Mon, 16 Feb 2004, Colin Gillespie wrote:
> Dear All,
>
> I which to insert text (more than 1000 lines) into a single cell of my table, should I use COPY here or INSERT?
>
> My reading seems to suggest that you would use COPY for mulitple INSERTs, but when inserting alot of data into one cell, INSERT is fine. Is this correct?
>
> Thanks
>
> Colin
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Crombleholme, Roy | 2004-02-18 09:21:21 | Re: Unable to connect to PostgreSQL server: |
| Previous Message | Wim | 2004-02-18 07:55:55 | Re: Big databases vs small databases |