Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
Re: Table maintenance: order of operations important?
- From: Gaetano Mendola <mendola(at)bigfoot(dot)com>
- To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
- To: pgsql-admin(at)postgresql(dot)org
- Subject: Re: Table maintenance: order of operations important?
- Date: Thu, 20 May 2004 20:53:51 +0200
- Message-id: <40ACFEBF.7000406@bigfoot.com> <text/plain>
Tom Lane wrote:
Jeff Boes <mur(at)qtm(dot)net> writes: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?If you are going to CLUSTER then the VACUUM and the REINDEX are both utterly redundant.
Without cluster with 7.4.2 a REINDEX is redundant after a VACUUM FULL ? Regards Gaetano Mendola
- References:
- Table maintenance: order of operations important?
- From: Jeff Boes
- Re: Table maintenance: order of operations important?
- From: Tom Lane
- Table maintenance: order of operations important?
- Prev by Date: tcpip_socket=false and psql is working?
- Next by Date: Exponential behaviour with UPDATE collisions?
- Previous by thread: Re: Table maintenance: order of operations important?
- Next by thread: Choosing a system
- Indexes: