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
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 keshishian||Date: 2006-04-13 01:26:10|
|Subject: pg 7.4.x - pg_restore impossibly slow|
|Previous:||From: Jim C. Nasby||Date: 2006-04-13 00:43:41|
|Subject: Re: multi column query|