Re: MS-server <-> Ppostgresql

From: Doug McNaught <doug(at)mcnaught(dot)org>
To: Felipe Schnack <felipes(at)ritterdosreis(dot)br>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: MS-server <-> Ppostgresql
Date: 2002-11-21 13:06:25
Message-ID: m3ptszhy26.fsf@varsoon.wireboard.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Felipe Schnack <felipes(at)ritterdosreis(dot)br> writes:

> Why copy is faster? You can do everything in a transaction turning off
> autocommit...

COPY will still be a little faster because each INSERT statement has
to go through the SQL parser and query planner. The parsing that COPY
does is a lot simpler.

-Doug

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Felipe Schnack 2002-11-21 13:09:02 Re: MS-server <-> Ppostgresql
Previous Message Shridhar Daithankar 2002-11-21 12:59:12 Re: MS-server <-> Ppostgresql