David Steele <david@xxxxxxxxxxxxx> writes: > On 2/26/15 5:23 PM, Alvaro Herrera wrote: >> It isn't. It also doesn't create any indexes, which you might want to >> do before analyze. > Is it necessary to create indexes before analyzing? > I usually do, just to be safe, but I thought statistics were based > solely on sampling of the heap. ANALYZE pays no attention to plain indexes. If you have any expression indexes, it will collect stats for those expressions. 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
