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 it disconnect and reconnect a lot?
Is it the main postmaster sucking up all the CPU, or the one spawned by
the PERL, or the one spawned by psql?
How much do the file system cache and io buffers grow?
______________________________________________________________________________
Your mouse has moved.
You must restart Windows for your changes to take effect.
#!/usr/bin/perl
print $i=pack(c5,(41*2),sqrt(7056),(unpack(c,H)-2),oct(115),10);