Table maintenance: order of operations important?
От
Jeff Boes
Тема
Table maintenance: order of operations important?
Дата
Msg-id
fe92d61c6c9a3eea2baa0b200ea5572f@news.teranews.com
Список
Дерево обсуждения
Table maintenance: order of operations important? Jeff Boes <mur@qtm.net>
Re: Table maintenance: order of operations important? Tom Lane <tgl@sss.pgh.pa.us>
Re: Table maintenance: order of operations important? Gaetano Mendola <mendola@bigfoot.com>
We have a number of tables from which we expire (delete) rows nightly. Is there any value to ordering the operations, in terms of either table physical organization or elapsed time? E.g., DELETE FROM foo WHERE date_expires < now(); VACUUM ANALYZE foo; CLUSTER foo; REINDEX TABLE foo; How would you choose to order these (under 7.4.x) for fastest turn-around? Does it matter? -- It may not always be easy, convenient, or politically correct to stand for truth and right, but it is the right thing to do. Always. ________ --M. Russell Ballard Jeffery Boes <>< mur@qtm.net
В списке pgsql-admin по дате отправления