Re: PostgreSQL Write Performance

From: Dimitri Fontaine <dfontaine(at)hi-media(dot)com>
To: Tim Uckun <timuckun(at)gmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: PostgreSQL Write Performance
Date: 2010-01-06 14:13:43
Message-ID: 87fx6js4mg.fsf@hi-media-techno.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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.

http://pgbulkload.projects.postgresql.org/

Regards,
--
dim

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Daniel Verite 2010-01-06 14:37:43 Re: set-level update fails with unique constraint violation
Previous Message Chris Ernst 2010-01-06 12:46:29 Re: incomplete startup packet