Re: Maximum Possible Insert Performance? - Mailing list pgsql-performance

From Joe Conway
Subject Re: Maximum Possible Insert Performance?
Date
Msg-id 3FC18BAF.7070506@joeconway.com
Whole thread Raw
In response to Maximum Possible Insert Performance?  (William Yu <wyu@talisys.com>)
List pgsql-performance
William Yu wrote:
> My situation is this. We have a semi-production server where we
> pre-process data and then upload the finished data to our production
> servers. We need the fastest possible write performance. Having the DB
> go corrupt due to power loss/OS crash is acceptable because we can
> always restore from last night and re-run everything that was done since
> then.

If you can, use COPY -- it is far faster than INSERT.

See:
http://www.postgresql.org/docs/current/static/sql-copy.html

HTH,

Joe



pgsql-performance by date:

Previous
From: Josh Berkus
Date:
Subject: Re: Maximum Possible Insert Performance?
Next
From: Shridhar Daithankar
Date:
Subject: Re: Maximum Possible Insert Performance?