Re: Vacuumdb error
| От | Carl von Clausewitz |
|---|---|
| Тема | Re: Vacuumdb error |
| Дата | |
| Msg-id | BANLkTikJMeO_=TPM-1bzgBV-QjNJ=kJ7+A@mail.gmail.com обсуждение исходный текст |
| Ответ на | Re: Vacuumdb error (Tom Lane <tgl@sss.pgh.pa.us>) |
| Ответы |
Re: Vacuumdb error
|
| Список | pgsql-general |
Ok thanks, the information. I've made the mistake, I will change the script, but I will try, that Vidhya told me. Let me see, what will going on.
Regards,
Carl
2011/4/14 Tom Lane <tgl@sss.pgh.pa.us>
Carl von Clausewitz <clausewitz45@gmail.com> writes:Just FYI, the reindex step is 100% useless if you're going to do a
> Maintenance:
> #!/bin/sh
> date >> /var/log/postgresql_maintenance.log
> /usr/local/bin/reindexdb --all --username=cvc >>
> /var/log/postgresql_maintenance.log
> echo "Reindex done" >> /var/log/postgresql_maintenance.log
> /usr/local/bin/vacuumdb --all --full --analyze --username=cvc >>
> /var/log/postgresql_maintenance.log
> echo "Vacuum done" >> /var/log/postgresql_maintenance.log
vacuum full afterwards.
Before 9.0 there was some value in doing vacuum full and then reindex,
but none whatsoever in the other ordering. As of 9.0 there's just no
point at all in doing both. VACUUM FULL rebuilds the indexes anyway.
regards, tom lane
В списке pgsql-general по дате отправления: