dinesh kumar <dineshkumar02@xxxxxxxxx> writes: > When we create an index, i believe the postgres engine it self update it's > catalog about the index availability. ANALYZE normally collects statistics about the contents of table columns. Thus, adding (or removing) an index does not create any reason to re-ANALYZE. However ... if you have an index on an expression (not just a simple column value), that cues ANALYZE to collect statistics about the values of that expression. So re-analyzing is useful after creating such an index, to give the planner a better idea of when to use that index. Whether you used CREATE INDEX CONCURRENTLY or some other way of creating the index doesn't matter at all. regards, tom lane -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
