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: (view raw, whole thread or download thread mbox)
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:

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

Postgresql & php tutorials

In response to


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-2017 The PostgreSQL Global Development Group