From: | Carl von Clausewitz <clausewitz45(at)gmail(dot)com> |
---|---|
To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Vacuumdb error |
Date: | 2011-04-14 16:52:17 |
Message-ID: | BANLkTikJMeO_=TPM-1bzgBV-QjNJ=kJ7+A@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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(at)sss(dot)pgh(dot)pa(dot)us>
> Carl von Clausewitz <clausewitz45(at)gmail(dot)com> writes:
> > 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
>
> Just FYI, the reindex step is 100% useless if you're going to do a
> 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
>
From | Date | Subject | |
---|---|---|---|
Next Message | Benjamin Smith | 2011-04-14 16:56:12 | Re: SSDs with Postgresql? |
Previous Message | Tom Lane | 2011-04-14 16:46:15 | Re: Vacuumdb error |