Re: COPY FROM STDIN instead of INSERT

From: "Ilja Golshtein" <ilejn(at)yandex(dot)ru>
To: pgsql(at)007Marketing(dot)com
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: COPY FROM STDIN instead of INSERT
Date: 2006-10-18 08:56:10
Message-ID: 4535EC2A.000007.15798@tide.yandex.ru
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello!

>Using COPY FROM STDIN is much faster than INSERT's (I am sure some out
>there have test times to compare, I don't have any on hand)

Yes, I know it is much faster.

The question is about possible pay for this quickness.

What if COPY, say, locks index until end of transaction (it is just an example, of course)? Such things are not so easy to discover during design or even test time.

>Sounds like your working with an existing database - if you are starting
>from scratch (inserting data into an empty database) then there are
>other things that can help too.

I am working with existing database, though I am interested what "other things" you mean.

Many thanks.

--
Best regards
Ilja Golshtein

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Nirmalya Lahiri 2006-10-18 09:22:14 Information regarding currently locked tables
Previous Message Stefan Sassenberg 2006-10-18 08:53:03 Re: ERRORDATA_STACK_SIZE exceeded