From: Andrew Dunstan <andrew@dunslane.net>
To: Bob Lunney <bob_lunney@yahoo.com>
Cc: Campbell, Lance <lance@illinois.edu>
Cc: pgsql-performance@postgresql.org <pgsql-performance@postgresql.org>
Subject: Re: database slowdown while a lot of inserts occur
Date: Thu, 29 Mar 2012 15:39:36 -0400
Message-ID: <4F74BA78.4090506@dunslane.net> (raw)
In-Reply-To: <1333049228.99470.YahooMailNeo@web162801.mail.bf1.yahoo.com>
References: <B75CD08C73BD3543B97E4EF3964B7D701E43F734@CITESMBX5.ad.uillinois.edu>
<B75CD08C73BD3543B97E4EF3964B7D701E440798@CITESMBX5.ad.uillinois.edu>
<1333049228.99470.YahooMailNeo@web162801.mail.bf1.yahoo.com>
On 03/29/2012 03:27 PM, Bob Lunney wrote:
> 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?
Or possibly a prepared statement called many times in a single
transaction, if you're not using that already. It's not as efficient as
COPY, but it's often a much less extensive change to the code.
cheers
andrew
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: andrew@dunslane.net, bob_lunney@yahoo.com, lance@illinois.edu
Subject: Re: database slowdown while a lot of inserts occur
In-Reply-To: <4F74BA78.4090506@dunslane.net>
* 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