From: Kelly Burkhart <kelly@tradebotsystems.com>
To: Ron Peacetree <rjpeace@earthlink.net>
Cc: pgsql-performance@postgresql.org
Subject: Re: 8.x index insert performance
Date: Thu, 10 Nov 2005 14:46:48 -0600
Message-ID: <1131655608.7514.51.camel@krb06.tradebot.com> (raw)
In-Reply-To: <867256.1130859455220.JavaMail.root@elwamui-norfolk.atl.sa.earthlink.net>
References: <867256.1130859455220.JavaMail.root@elwamui-norfolk.atl.sa.earthlink.net>
On Tue, 2005-11-01 at 10:37 -0500, Ron Peacetree wrote:
> I'm surprised that no one seems to have yet suggested the following
> simple experiment:
>
> Increase the RAM 4GB -> 8GB, tune for best performance, and
> repeat your 100M row insert experiment.
>
> Does overall insert performance change? Does the performance
> drop <foo> rows in still occur? Does it occur in ~ the same place?
> Etc.
>
> If the effect does seem to be sensitive to the amount of RAM in the
> server, it might be worth redoing the experiment(s) with 2GB and
> 16GB as well...
Ron,
I would like to try this, however, since I'm sitting about 1000 miles
away from the server, tweaking things is not as simple as one might
hope. I would also like to understand what is going on before I start
changing things. If I can't get a satisfactory explanation for what I'm
seeing with current hardware, I'll have memory added and see what
happens.
-K
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: kelly@tradebotsystems.com, rjpeace@earthlink.net
Subject: Re: 8.x index insert performance
In-Reply-To: <1131655608.7514.51.camel@krb06.tradebot.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