pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
VACUUM ANALYZE and REINDEX
2+ messages / 2 participants
[nested] [flat]

* VACUUM ANALYZE and REINDEX
@ 2004-07-19 19:25 Bill Chandler <billybobc1210@yahoo.com>
  2004-07-19 20:06 ` Re: VACUUM ANALYZE and REINDEX Scott Marlowe <smarlowe@qwest.net>
  0 siblings, 1 reply; 2+ messages in thread

From: Bill Chandler @ 2004-07-19 19:25 UTC (permalink / raw)
  To: pgsql-admin

Hello,

I'm sorry if this too basic.  I searched the web but
could not find an answer.

Q1: When you do a VACUUM ANALYZE does it update the
statistics for existing indexes on the table?  Or do
you have to do an explicit REINDEX command on the
index (or possibly drop and recreate the index)?

thanks,

Bill


		
__________________________________
Do you Yahoo!?
Vote for the stars of Yahoo!'s next ad campaign!
http://advision.webevents.yahoo.com/yahoo/votelifeengine/




^ permalink  raw  reply  [nested|flat] 2+ messages in thread

* Re: VACUUM ANALYZE and REINDEX
  2004-07-19 19:25 VACUUM ANALYZE and REINDEX Bill Chandler <billybobc1210@yahoo.com>
@ 2004-07-19 20:06 ` Scott Marlowe <smarlowe@qwest.net>
  0 siblings, 0 replies; 2+ messages in thread

From: Scott Marlowe @ 2004-07-19 20:06 UTC (permalink / raw)
  To: Bill Chandler <billybobc1210@yahoo.com>; +Cc: pgsql-admin

On Mon, 2004-07-19 at 13:25, Bill Chandler wrote:
> Hello,
> 
> I'm sorry if this too basic.  I searched the web but
> could not find an answer.
> 
> Q1: When you do a VACUUM ANALYZE does it update the
> statistics for existing indexes on the table?  Or do
> you have to do an explicit REINDEX command on the
> index (or possibly drop and recreate the index)?

analyze has no effect on indexes, it is performed on the tables
directly.  The stats are then used to decide when to use / not use an
index.  Reindexing is used to fix broken or bloated indexes, and is not
related to analyze.




^ permalink  raw  reply  [nested|flat] 2+ messages in thread


end of thread, other threads:[~2004-07-19 20:06 UTC | newest]

Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2004-07-19 19:25 VACUUM ANALYZE and REINDEX Bill Chandler <billybobc1210@yahoo.com>
2004-07-19 20:06 ` Scott Marlowe <smarlowe@qwest.net>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox