> Sure looks like a near-idle machine to me :-(. > I think that the vacuum must be stuck on a lock. What other Postgres processes have you got, and what are they doing? > regards, tom lane Originally I thought it was the autovacuuming getting in the way since I noticed sometimes it was trying to vacuum the tables I was trying to vacuum and autovacuuming was taking a long time, but I had turned autovacuuming off during bulk load process period to prevent this. When I showed you the stats on only the vacuuming, I had already stopped all bulk load processes such that Running SELECT * FROM pg_stat_activity Was showing nothing but my single vacuuming process. If I vacuum say a 365,0000 record table of comparable structure to my 1 million someodd, it takes about 10 minutes to run and runs thru. 10 minutes for 365,000 records seemed a little long to me from memory on 8.2, but at least it ran thru okay. Next I was going to try to do was load the same dataset on my old 8.2 box to rule out 8.3.1 as the culprit. Thanks, Regina
