On Thu, Mar 29, 2012 at 12:02 PM, Campbell, Lance <lance@xxxxxxxxxxxx> wrote: > I forgot to mention that the slowdown in particular for other applications > is when they are trying to insert or update tables unrelated to the > application mentioned in my prior application that does the massive small > inserts. It sounds like you're just flooding your IO channels. Can you throttle your write rate in your main application that's inserting so many inserts? Something that sleeps 10ms between every hundred rows or some such? -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
