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/