Joost Kraaijeveld <[EMAIL PROTECTED]> 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 > combination.
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 transactions. regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend