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

Inserts optimization?

From: Francisco Reyes <lists(at)stringsutils(dot)com>
To: Pgsql performance <pgsql-performance(at)postgresql(dot)org>
Subject: Inserts optimization?
Date: 2006-04-13 00:38:58
Message-ID: cone.1144888738.434948.92126.5001@35st-server.simplicato.com (view raw or flat)
Thread:
Lists: pgsql-performance
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 anyone recalls a previous thread like this please suggest keywords to 
search on. My search on this topic came back pretty empty.

Responses

pgsql-performance by date

Next:From: Jim C. NasbyDate: 2006-04-13 00:43:41
Subject: Re: multi column query
Previous:From: Tom LaneDate: 2006-04-13 00:35:14
Subject: Re: pgmemcache

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