From: Bob Lunney <bob_lunney@yahoo.com>
To: Campbell, Lance <lance@illinois.edu>
To: pgsql-performance@postgresql.org <pgsql-performance@postgresql.org>
Subject: Re: database slowdown while a lot of inserts occur
Date: Thu, 29 Mar 2012 12:27:08 -0700 (PDT)
Message-ID: <1333049228.99470.YahooMailNeo@web162801.mail.bf1.yahoo.com> (raw)
In-Reply-To: <B75CD08C73BD3543B97E4EF3964B7D701E440798@CITESMBX5.ad.uillinois.edu>
References: <B75CD08C73BD3543B97E4EF3964B7D701E43F734@CITESMBX5.ad.uillinois.edu>
<B75CD08C73BD3543B97E4EF3964B7D701E440798@CITESMBX5.ad.uillinois.edu>
Lance,
May small inserts cause frequent fsyncs. Is there any way those small inserts can be batched into some larger sets of inserts that use copy to perform the load?
Bob Lunney
________________________________
From: "Campbell, Lance" <lance@illinois.edu>
To: "Campbell, Lance" <lance@illinois.edu>; "pgsql-performance@postgresql.org" <pgsql-performance@postgresql.org>
Sent: Thursday, March 29, 2012 1:02 PM
Subject: Re: [PERFORM] database slowdown while a lot of inserts occur
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@postgresql.org [mailto:pgsql-performance-owner@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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: bob_lunney@yahoo.com, lance@illinois.edu
Subject: Re: database slowdown while a lot of inserts occur
In-Reply-To: <1333049228.99470.YahooMailNeo@web162801.mail.bf1.yahoo.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox