It is running on many transactions. At least after 5 inserts a transaction is commited.
The filesystems doesn't get slow (reading a (big) file works still at >20 MBytes/s).
14839 postgres 20 0 19948 19M 18980 R98.5 7.7 477:24 postmaster
14819 postgres 8 0 1856 1856 1700 S 0.0
Is this running as one transaction, or is it not a transaction? Have you
tried committing every 10,000 or so if it is in one transaction? It could
be a logging problem with the transaction being too big.
Does the file system as a whole get slow, or just Postgres? Is it one
connection, or does
I am running the precomplied binary of Postgreql 7.1.2 on a Redhat 7.1 (on a Dual
Celeron System with 256MB, kernel 2.4.4 and 2.4.5) System.
(The installation of the new 7.1.3 doesn't seem to solve the problem)
I am connecting to the DB with a Perl Program (using Perl 5.6.0 with DBD-Pg-1.01 and
I am running the precomplied binary of Postgreql 7.1.2 on a Redhat 7.1 (on a Dual
Celeron System with 256MB, kernel 2.4.4 and 2.4.5) System.
(The installation of the new 7.1.3 doesn't seem to solve the problem)
I am connecting to the DB with a Perl Program (using Perl 5.6.0 with DBD-Pg-1.01 and
