Re: [PERFORM] Heavy inserts load wile querying...

2012-07-24 Thread Ioannis Anagnostopoulos
On 24/07/2012 15:30, Craig James wrote: On Tue, Jul 24, 2012 at 6:22 AM, Ioannis Anagnostopoulos mailto:ioan...@anatec.com>> wrote: Hello, The Postres 9.0 database we use gets about 20K inserts per minute. As long as you don't query at the same time the database is copying fi

Re: [PERFORM] Heavy inserts load wile querying...

2012-07-24 Thread Craig James
On Tue, Jul 24, 2012 at 6:22 AM, Ioannis Anagnostopoulos wrote: > Hello, > The Postres 9.0 database we use gets about 20K inserts per minute. As long > as you don't query at the same time the database is copying fine. However > long running queries seems to delay so much the db that the applicati

[PERFORM] Heavy inserts load wile querying...

2012-07-24 Thread Ioannis Anagnostopoulos
Hello, The Postres 9.0 database we use gets about 20K inserts per minute. As long as you don't query at the same time the database is copying fine. However long running queries seems to delay so much the db that the application server buffers the incoming data as it cannot insert them fast eno