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

Re: Inserts optimization?

From: Chris <dmagick(at)gmail(dot)com>
To: Francisco Reyes <lists(at)stringsutils(dot)com>
Cc: Pgsql performance <pgsql-performance(at)postgresql(dot)org>
Subject: Re: Inserts optimization?
Date: 2006-04-13 01:19:17
Message-ID: 443DA715.4060606@gmail.com (view raw or flat)
Thread:
Lists: pgsql-performance
Francisco Reyes wrote:
> Doing my first write heavy database.
> What settings will help improve inserts?
> Only a handfull of connections, but each doing up to 30 inserts/second.
> Plan to have 2 to 3 clients which most of the time will not run at the 
> same time, but ocasionaly it's possible two of them may bump into each 
> other.

If you can, use copy instead:

http://www.postgresql.org/docs/8.1/interactive/sql-copy.html

MUCH quicker (and don't worry about using multiple clients).

-- 
Postgresql & php tutorials
http://www.designmagick.com/

In response to

Responses

pgsql-performance by date

Next:From: patrick keshishianDate: 2006-04-13 01:26:10
Subject: pg 7.4.x - pg_restore impossibly slow
Previous:From: Jim C. NasbyDate: 2006-04-13 00:43:41
Subject: Re: multi column query

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