Re: COPY vs INSERT

From: Christopher Kings-Lynne <chriskl(at)familyhealth(dot)com(dot)au>
To: David Roussel <pgsql-performance(at)diroussel(dot)xsmail(dot)com>
Cc: Mischa Sandberg <mischa(dot)sandberg(at)telus(dot)net>, pgsql-perform <pgsql-performance(at)postgresql(dot)org>
Subject: Re: COPY vs INSERT
Date: 2005-05-05 01:51:22
Message-ID: 42797C1A.3090303@familyhealth.com.au
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Tom Lane 2005-05-05 02:22:56 Re: COPY vs INSERT
Previous Message Kris Jurka 2005-05-04 23:33:50 Re: COPY vs INSERT