Hello all,

I'm putting together a database that has me wondering about the interaction of ANALYZE
with indices.  I guess the basic question is: are indices affected by the results of

The particular application I've got is doing a batch insert of lots of records.  For
performance, I'm dropping the indexes on the table, doing the inserts, then recreating
the indexes a then doing a VACUUM ANALYZE.  Specifically, I'm wondering if I should do
the ANALYZE before or after I recreate the indexes, or whether it matters.

Any feedbackis welcome.

Bill Moran
Potential Technologies

---------------------------(end of broadcast)--------------------------- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match

Reply via email to