Page 1 of 1

Vacuuming Taking Forever

PostPosted: Sun Jul 27, 2008 11:13 am
by kensmoe8
I'm currently vaccuuming my database and it seems to be taking a lot longer than it should. I know the timing all depends on how large the database is, and I realize that mine is probably pretty large, but it has been running for close to 24 hours. Is this normal? I'm using beta 15.

Re: Vacuuming Taking Forever

PostPosted: Sun Jul 27, 2008 11:19 am
by WhiteRider
I wouldn't expect it to take that long, even for a big DB.
Beta 15 does have a vacuum which does a bit more work than previously, but still it shouldn't take that long.
I'm not absolutely sure, but I think I remember some of the postgres experts saying that you won't do any harm to the DB by stopping the vacuum.

Re: Vacuuming Taking Forever

PostPosted: Sun Jul 27, 2008 12:18 pm
by kensmoe8
Thanks. I'll try to stop the vacuum, restart postgres (prob. just reboot machine) and try again.

highfalutin