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