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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse pgsql-performance by date

  From Date Subject
Next Message Jim C. Nasby 2006-04-13 00:43:41 Re: multi column query
Previous Message Tom Lane 2006-04-13 00:35:14 Re: pgmemcache