Re: MS-server <-> Ppostgresql - Mailing list pgsql-general

From Doug McNaught
Subject Re: MS-server <-> Ppostgresql
Date
Msg-id m3ptszhy26.fsf@varsoon.wireboard.com
Whole thread Raw
In response to Re: MS-server <-> Ppostgresql  ("Shridhar Daithankar" <shridhar_daithankar@persistent.co.in>)
List pgsql-general
Felipe Schnack <felipes@ritterdosreis.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

pgsql-general by date:

Previous
From: "Shridhar Daithankar"
Date:
Subject: Re: MS-server <-> Ppostgresql
Next
From: "Williams, Travis L, NPONS"
Date:
Subject: tcpip connections..