Re: database slowdown while a lot of inserts occur

can you post all the configuration parameters related to the I/O activity?
plus, could you post some stats from 'iostat' when this is happening?
thx

On Thu, Mar 29, 2012 at 9:02 PM, Campbell, Lance <lance(at)illinois(dot)edu> 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.****
>
> ** **
>
> ** **
>
> Thanks,****
>
> ** **
>
> Lance Campbell****
>
> Software Architect****
>
> Web Services at Public Affairs****
>
> 217-333-0382****
>
> ** **
>
> *From:* pgsql-performance-owner(at)postgresql(dot)org [mailto:
> pgsql-performance-owner(at)postgresql(dot)org] *On Behalf Of *Campbell, Lance
> *Sent:* Thursday, March 29, 2012 12:59 PM
> *To:* pgsql-performance(at)postgresql(dot)org
> *Subject:* [PERFORM] database slowdown while a lot of inserts occur****
>
> ** **
>
> PostgreSQL 9.0.x****
>
> We have around ten different applications that use the same database.
> When one particular application is active it does an enormous number of
> inserts. Each insert is very small. During this time the database seems
> to slow down in general. The application in question is inserting into a
> particular table that is not used by the other applications.****
>
> ** **
>
> **1) **What should I do to confirm that the database is the issue
> and not the applications?****
>
> **2) **How can I identify where the bottle neck is occurring if the
> issue happens to be with the database?****
>
> ** **
>
> I have been using PostgreSQL for eight years. It is an amazing database.*
> ***
>
> ** **
>
> Thanks,****
>
> ** **
>
> Lance Campbell****
>
> Software Architect****
>
> Web Services at Public Affairs****
>
> 217-333-0382****
>
> ** **
>