Skip site navigation (1) Skip section navigation (2)

Re: Maximum Possible Insert Performance?

From: Joe Conway <mail(at)joeconway(dot)com>
To: William Yu <wyu(at)talisys(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Maximum Possible Insert Performance?
Date: 2003-11-24 04:40:15
Message-ID: 3FC18BAF.7070506@joeconway.com (view raw or flat)
Thread:
Lists: 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



In response to

pgsql-performance by date

Next:From: Shridhar DaithankarDate: 2003-11-24 05:50:36
Subject: Re: Maximum Possible Insert Performance?
Previous:From: Josh BerkusDate: 2003-11-24 04:29:04
Subject: Re: Maximum Possible Insert Performance?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group