I am running a more or less out the box Postgresql installation which is running really slowly.
I am parsing a whole bunch of logs files using Perl and using Perl's DBI interface (connecting to the database via the IP address 127.0.0.1) to add the data to the database. My database has around 4 tables. My script basically checks to see whether the normalized data already exists. If the data does not exist it adds it to the database. Otherwise it extracts the keys to use to update other tables.
I am running on more or less desktop hardware with 2GB RAM but I was not expecting it to well over 5 days to add round 12 million rows.
PS. I did increase the size of my shared_buffers to 25% of my RAM but this did not make much of a difference.
Any tips will be appreciated.
Edit: I am running Ubuntu Linux