Re: delete/vacuum not freeing disk space

Поиск
Список
Период
Сортировка
От marc@oscar.eng.cv.net (Marc Spitzer)
Тема Re: delete/vacuum not freeing disk space
Дата
Msg-id slrn9sia13.lsm.marc@oscar.eng.cv.net
обсуждение исходный текст
Ответ на Re: delete/vacuum not freeing disk space  (Brian McCane <bmccane@mccons.net>)
Ответы Re: delete/vacuum not freeing disk space  (Brian McCane <bmccane@mccons.net>)
Список pgsql-admin
In article <20011012165439.S71408-100000@fw.mccons.net>, Brian McCane wrote:
>
> Being the perpetually lazy person that I am, I have written a PERL script
> that takes care of indexes on a live system.  You tell the script the
> database and table to reindex.  It then finds a list of indexes for the
> table and creates exactly the same index, with a slightly modified name.
> After the copy is made the old index is DROP'd, and the new one is
> ALTER'd to the old name.  Unfortunately, this means that you must have
> enough room for the new index plus the old at the same time, but I am
> sure that most people have lots of spare room.  I seem to remember that
> the last time I ran this, it didn't even stop my websites from using the
> tables at the same time.  I assume this is because of the versioning
> system used in PostgreSQL.
>
> - brian
>
> Wm. Brian McCane                    | Life is full of doors that won't open
> Search http://recall.maxbaud.net/   | when you knock, equally spaced amid those
> Usenet http://freenews.maxbaud.net/ | that open when you don't want them to.
> Auction http://www.sellit-here.com/ | - Roger Zelazny "Blood of Amber"
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
>     (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)

would you consider posting that script or emailing it to me?
It would realy come in handy at work.

Thanks

marc

В списке pgsql-admin по дате отправления:

Предыдущее
От: Chris Pesko
Дата:
Сообщение: How do you manage WAL logs......
Следующее
От: Russ McBride
Дата:
Сообщение: tcl wish--simple configure problem