Postgres Pro
Downloads
Home   >   mailing lists

ANALYZE and indexes (was Re: Sort time) - Mailing list pgsql-performance

From Tom Lane
Subject ANALYZE and indexes (was Re: Sort time)
Date
Msg-id 2523.1037401335@sss.pgh.pa.us
Whole thread Raw
In response to Re: Sort time  ("Josh Berkus" <josh@agliodbs.com>)
List pgsql-performance
Tree view 
"Josh Berkus" <josh@agliodbs.com> writes:
> ... don't forget to VACUUM ANALYZE after you index ...

People keep saying that, but it's a myth.  ANALYZE doesn't care what
indexes are present; adding or deleting an index doesn't invalidate
previous ANALYZE results.

            regards, tom lane

pgsql-performance by date:

Previous
From: Rod Taylor
Date:
Subject: Re: Sort time
Next
From: Tom Lane
Date:
Subject: Re: Sort time