From: Wolfgang Gehner <wgehner@infonoia.com>
To: pgsql-performance@postgresql.org
Subject: slow insert into very large table
Date: Thu, 01 Dec 2005 13:33:21 +0100
Message-ID: <438EED91.9080302@infonoia.com> (raw)
Hi there,
I need a simple but large table with several million records. I do batch
inserts with JDBC. After the first million or so records,
the inserts degrade to become VERY slow (like 8 minutes vs initially 20
secondes).
The table has no indices except PK while I do the inserts.
This is with PostgreSQL 8.0 final for WindowsXP on a Pentium 1.86 GHz,
1GB Memory. HD is fast IDE.
I already have shared buffers already set to 25000.
I wonder what else I can do. Any ideas?
Kindest regards,
Wolfgang Gehner
--
Infonoia SA
7 rue de Berne
1211 Geneva 1
Tel: +41 22 9000 009
Fax: +41 22 9000 018
http://www.infonoia.com
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: wgehner@infonoia.com
Subject: Re: slow insert into very large table
In-Reply-To: <438EED91.9080302@infonoia.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