Re: [PERFORM] Performance over a LAN

2004-07-22 Thread Scott Marlowe
On Thu, 2004-07-22 at 23:50, William Carney wrote: > Hello, > > Using a test client application that performs 10 insert operations on a > table, with the client application running on the same machine as the > Postgres server, I get the following results for the time taken to run the > test: >

Re: [PERFORM] Performance over a LAN

2004-07-22 Thread Mark Aufflick
I don't think that's the advice being looked for here - if this behaviour is repeatable, then there is something askew with the inet protocol. What is the client application written in? Do you know what version of the postgres network protocol your driver code is using? Are the inserts ins

Re: [PERFORM] Performance over a LAN

2004-07-22 Thread Christopher Kings-Lynne
But with the server running on one machine and the client running on another, the two machines being connected by a 100 Mb ethernet, with nothing else on the network, this test takes 17 minutes to run. I have tried changing the frequency of COMMIT operations, but with only a small effect. Are you u

[PERFORM] Performance over a LAN

2004-07-22 Thread William Carney
Hello, Using a test client application that performs 10 insert operations on a table, with the client application running on the same machine as the Postgres server, I get the following results for the time taken to run the test: Unix domain socket connection: 26 seconds Inet domain socket ('