slow insert into very large table
От
Wolfgang Gehner
Тема
slow insert into very large table
Дата
Msg-id
438EED91.9080302@infonoia.com
Список
Дерево обсуждения
slow insert into very large table Wolfgang Gehner <wgehner@infonoia.com>
Re: slow insert into very large table Tom Lane <tgl@sss.pgh.pa.us>
Re: slow insert into very large table Andreas Pflug <pgadmin@pse-consulting.de>
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
В списке pgsql-performance по дате отправления
От: Bill McGonigle
Дата: