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
Дата:
От: Michael Riess
Дата:
Сообщение: 15,000 tables
FAQ