HELP: Urgent, Vacuum problem
| От | Schwenker, Stephen |
|---|---|
| Тема | HELP: Urgent, Vacuum problem |
| Дата | |
| Msg-id | FBEF1EF7B7E5B649AB1C684991223C6E02643C56@tmg-mail2.torstar.net обсуждение исходный текст |
| Ответы |
Re: HELP: Urgent, Vacuum problem
Re: HELP: Urgent, Vacuum problem Re: HELP: Urgent, Vacuum problem Re: HELP: Urgent, Vacuum problem Re: HELP: Urgent, Vacuum problem |
| Список | pgsql-general |
Hello,
I'm having a major Vacuuming problem. I used to do a full vacuum every morning on my postgres database to clean up empty space on a table but because of it's size, the locking of the database causes my application server to max out the database connections and causes database errors. To fix that problem, I have turned off the full vacuum and are just doing a standard analyze vacuum. No I'm getting very close to running out of space on my disks because the table keeps on growing and the database is not re-using deleted record space. I know this because I delete 99% of the records from the table after I have exported them but the size of the database tables are not decreasing. Now I can't shrink the size of the tables because the full vacuum takes too long to run Over 2 hours and locks the table for too long.
Can anyone help me with fixing my problem with vacuuming and disk space?
I'm using version 7.4.2 on solaris.
Thank you,
Steve.
В списке pgsql-general по дате отправления: