From: Martijn van Oosterhout <kleptog@svana.org>
To: Samuel J. Sutjiono <ssutjiono@wc-group.com>
Cc: pgsql-general@postgresql.org
Cc: pgsql-sql@postgresql.org
Subject: Re: Performance issues with compaq server
Date: Wed, 8 May 2002 11:25:27 +1000
Message-ID: <20020508112527.A17584@svana.org> (raw)
In-Reply-To: <001501c1f618$32d0d780$110a010a@headquarters.wcgroup.com>
References: <001501c1f618$32d0d780$110a010a@headquarters.wcgroup.com>
On Tue, May 07, 2002 at 06:40:32PM -0400, Samuel J. Sutjiono wrote:
> I tried to load data using insert statement to our new database server
> (Compaq DL580, DL590, DL380 using SCSI driver) but it was very very slow.
> The database runs on Red Hat Linux 7.2 and PostgreSQL version 7.1.3
>
> Does anybody know any idea to what cause this problem ? or things that I
> need to look or check (in the config. file)
Put them in a trasaction (begin/commit). Without that, each insert becomes
it's own transaction which is rather expensive. Postgresql 7.2 improves this
a bit but the transaction will help anyway.
HTH,
--
Martijn van Oosterhout <kleptog@svana.org> http://svana.org/kleptog/> Canada, Mexico, and Australia form the Axis of Nations That
> Are Actually Quite Nice But Secretly Have Nasty Thoughts About America
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-sql@postgresql.org
Cc: kleptog@svana.org, ssutjiono@wc-group.com, pgsql-general@postgresql.org
Subject: Re: Performance issues with compaq server
In-Reply-To: <20020508112527.A17584@svana.org>
* 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