Re: PostgreSQL Write Performance

From: Tim Uckun <timuckun(at)gmail(dot)com>
To: Dimitri Fontaine <dfontaine(at)hi-media(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: PostgreSQL Write Performance
Date: 2010-01-06 20:46:51
Message-ID: 855e4dcf1001061246p4c684cev25ea5f37509ad98c@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Thu, Jan 7, 2010 at 3:13 AM, Dimitri Fontaine <dfontaine(at)hi-media(dot)com> wrote:
> Tim Uckun <timuckun(at)gmail(dot)com> writes:
>> Is there a command like COPY which will insert the data but skip all
>> triggers and optionally integrity checks.
>
> pg_bulkload does that AFAIK.
>

That's a great utility. Unfortunately since it bypasses the WAL I
can't use it for this project but thanks for the pointer.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Steve Wampler 2010-01-06 20:57:18 Re: timestamp fields and order by?
Previous Message Tom Lane 2010-01-06 20:46:39 Re: timestamp fields and order by?