> 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





--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general