"Scott Marlowe" <scott.marlowe@xxxxxxxxx> writes: > The order doesn't matter. Analyze doesn't know anything about the > indexes, it knows about the fields / tables. I.e. if you run analyze, > then create the index, you get the same basic result as if you create > the index then run analyze. There is an exception to that statement, which is indexes on functions (expressions). Existence of such an index prompts analyze to gather stats about the indexed expression. For plain column indexes, you're right, it doesn't matter. 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
