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

Re: How import big amounts of data?

From: Arnau <arnaulist(at)andromeiberica(dot)com>
To: Teemu Torma <teemu(at)torma(dot)org>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: How import big amounts of data?
Date: 2005-12-29 16:19:27
Message-ID: 43B40C8F.6010100@andromeiberica.com (view raw or flat)
Thread:
Lists: pgsql-performance
> 
> I am doing twice as big imports daily, and found the follwing method 
> most efficient (other than using copy):
> 
> - Use plpgsql function to do the actual insert (or update/insert if 
> needed). 
> 
> - Inside a transaction, execute SELECT statements with maximum possible 
> number of insert function calls in one go.  This minimizes the number 
> of round trips between the client and the server.

Thanks Teemu! could you paste an example of one of those functions? ;-) 
An example of those SELECTS also would be great, I'm not sure I have 
completly understood what you mean.

-- 
Arnau

In response to

Responses

pgsql-performance by date

Next:From: Teemu TormaDate: 2005-12-29 17:05:45
Subject: Re: How import big amounts of data?
Previous:From: Teemu TormaDate: 2005-12-29 14:41:05
Subject: Re: How import big amounts of data?

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