Joost Kraaijeveld <J(dot)Kraaijeveld(at)Askesis(dot)nl> writes:
> I will test this a for perfomance improvement, but still, I wonder if ~
> 100 inserts/second is a reasonable performance for my software/hardware
Is the client code running on the same machine as the database server?
If not, what's the network delay and latency between them?
The major problem you're going to have here is at least one network
round trip per row inserted --- possibly more, if the jdbc driver is
doing "helpful" stuff behind your back like starting/committing
regards, tom lane
In response to
pgsql-performance by date
|Next:||From: Joost Kraaijeveld||Date: 2005-09-23 14:47:04|
|Subject: Re: How to determine cause of performance problem?|
|Previous:||From: Bruno Wolff III||Date: 2005-09-23 14:20:27|
|Subject: Re: VACUUM FULL vs CLUSTER|