Contrib reindex script:
От | Shaun Thomas |
---|---|
Тема | Contrib reindex script: |
Дата | |
Msg-id | Pine.LNX.4.44.0205070843420.16874-200000@hamster.lee.net обсуждение исходный текст |
Ответы |
Re: Contrib reindex script:
Re: Contrib reindex script: |
Список | pgsql-general |
I modeled this after the vacuumdb script that is distributed in the postgresql-base distribution. It can reindex a whole database, specific tables, or just a single index. Being as we've had so much trouble with things growing out of control, and the group seems to have tracked it down to indexes, here it is. I don't understand why we have a vacuumdb script, but not a reindex script, considering the fact that vacuum doesn't clean up indexes. Anyway, I didn't bother to comment it, I just copied vacuumdb and changed relevant parts. It's not pretty, but it works. Maybe later I'll produce one that doesn't look like it was coughed up by a robot. -- +-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-+ | Shaun M. Thomas INN Database Administrator | | Phone: (309) 743-0812 Fax : (309) 743-0830 | | Email: sthomas@townnews.com AIM : trifthen | | Web : www.townnews.com | | | | "Most of our lives are about proving something, either to | | ourselves or to someone else." | | -- Anonymous | +-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-+
Вложения
В списке pgsql-general по дате отправления: