From: | Filippos Kalamidas <filippos(dot)kal(at)gmail(dot)com> |
---|---|
To: | "Campbell, Lance" <lance(at)illinois(dot)edu> |
Cc: | "pgsql-performance(at)postgresql(dot)org" <pgsql-performance(at)postgresql(dot)org> |
Subject: | Re: database slowdown while a lot of inserts occur |
Date: | 2012-03-29 18:14:05 |
Message-ID: | CANUP4k29mnE6v9cKufP_Z6_owcjtvhmc_9Y7wWv5Ff-dSa2Tew@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-performance |
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****
>
> ** **
>
From | Date | Subject | |
---|---|---|---|
Next Message | Deron | 2012-03-29 18:17:24 | Re: database slowdown while a lot of inserts occur |
Previous Message | Campbell, Lance | 2012-03-29 18:02:47 | Re: database slowdown while a lot of inserts occur |