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: | Raw Message | Whole Thread | 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 |