Best approach for large table maintenance
От | Vanole, Mike |
---|---|
Тема | Best approach for large table maintenance |
Дата | |
Msg-id | C9C075DB3961464180CE3DEF766B4A2C07EB4376@ad01msxmb007.US.Cingular.Net обсуждение исходный текст |
Ответы |
Re: Best approach for large table maintenance
|
Список | pgsql-general |
Hi, I have an application where I drop, recreate, reload, and recreate indexes on a 1 million row table each day. I do this to avoid having to run vacuum on the table in the case where I might use DELETE or UPDATEs on deltas. It seems that running vacuum still has value in the above approach because I still see index row versions were removed. I do not explicitly drop the indexes because they are dropped with the table. In considering the use of TRUNCATE I sill have several indexes that if left in place would slow down the data load. My question is, what is the best way to manage a large table that gets reloaded each day? Drop Create Table Load (copy or insert/select) Create Indexes Vacuum anyway? Or... DROP indexes Truncate Load (copy or insert/select) Create Indexes And is vacuum still going to be needed? Many Thanks, Mike
В списке pgsql-general по дате отправления: