I am trying to firgure out what the best order is?
I was thinking
Vacuum Full table;
I belive the vacuum full should be done first as it will remove the rows where no data exits so that when it is clustered it will be a perfect table, then analyze to build the info for the table.
Also where should the reindex's come in and should they be done?
pgsql-general by date
|Next:||From: Tom Lane||Date: 2004-08-27 18:43:45|
|Subject: Re: performance of IN (subquery) |
|Previous:||From: Tom Lane||Date: 2004-08-27 18:25:05|
|Subject: Re: Strange difference in query execution time |