Re: COPY vs INSERT - Mailing list pgsql-performance

From Christopher Kings-Lynne
Subject Re: COPY vs INSERT
Date
Msg-id 42797C1A.3090303@familyhealth.com.au
Whole thread Raw
In response to Re: COPY vs INSERT  ("David Roussel" <pgsql-performance@diroussel.xsmail.com>)
Responses Re: COPY vs INSERT  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-performance
> So what's the difference between a COPY and a batch of INSERT
> statements.  Also, surely, fsyncs only occur at the end of a
> transaction, no need to fsync before a commit has been issued, right?

With COPY, the data being inserted itself does not have to pass through
the postgresql parser.

Chris

pgsql-performance by date:

Previous
From: Kris Jurka
Date:
Subject: Re: COPY vs INSERT
Next
From: Tom Lane
Date:
Subject: Re: COPY vs INSERT