Re: [PERFORM] PostgreSQL 8.2.5 slow performance on INSERT on Linux

2007-12-02 Thread Beyers Cronje
> > Your development system is probably running inexpensive IDE disks that > cache writes, while the test server is not caching. If you loop over > single inserts, PostgreSQL's default configuration will do a physical > commit to disk after every one of them, which limits performance to how > fast

Re: [PERFORM] PostgreSQL 8.2.5 slow performance on INSERT on Linux

2007-12-02 Thread Greg Smith
On Sun, 2 Dec 2007, Beyers Cronje wrote: Initially I tested this on my development PC, an old P4 system with 2GB RAM and 10,000 INSERTs took ~12 secs on average, which I was fairly satisfied with. I then moved everything over to our test server, a new Dell 1950 server with quad core Xeon proce

Re: [PERFORM] PostgreSQL 8.2.5 slow performance on INSERT on Linux

2007-12-02 Thread Pavel Stehule
On 02/12/2007, Beyers Cronje <[EMAIL PROTECTED]> wrote: > Hi all, > > I'm busy evaluating PostgreSQL and I'm having performance problems on one of > my servers. I have a very simple one table database, and the client using > Mono 1.2.5.1 is running a loop doing INSERTs on the table. Initially I > t

[PERFORM] PostgreSQL 8.2.5 slow performance on INSERT on Linux

2007-12-02 Thread Beyers Cronje
Hi all, I'm busy evaluating PostgreSQL and I'm having performance problems on one of my servers. I have a very simple one table database, and the client using Mono 1.2.5.1 is running a loop doing INSERTs on the table. Initially I tested this on my development PC, an old P4 system with 2GB RAM and