No, it is one transaction per insert.
-----Original Message-----
From: Scott Marlowe [mailto:[EMAIL PROTECTED]
Sent: Tuesday, May 08, 2007 5:38 PM
To: Orhan Aglagul
Subject: RE: [PERFORM]
On Tue, 2007-05-08 at 19:36, Orhan Aglagul wrote:
> But 10,000 records in 65 sec comes to ~153 records per second. On a
dual
> 3.06 Xeon....
> What range is acceptable?
If you're doing that in one big transaction, that's horrible. Because
it shouldn't be waiting for each insert to fsync, but the whole
transaction.
---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?
http://archives.postgresql.org
