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 <la...@illinois.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-ow...@postgresql.org [mailto: > pgsql-performance-ow...@postgresql.org] *On Behalf Of *Campbell, Lance > *Sent:* Thursday, March 29, 2012 12:59 PM > *To:* pgsql-performance@postgresql.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**** > > ** ** >
