> > Does the "multiple steps" part involve UPDATEs on pre-existing rows? > Do the updates change the column(s) used in the gin index? >
Yes they do, however the updates happen prior to the index creation. I just tried, and that looks like the solution. I really appreciate your help on this. Is there any easy way I can know if an index is usable or not? Are there any catalog views or anything I could check that in? Thanks, -Adam