Hi, When we create an index, i believe the postgres engine it self update it's catalog about the index availability.
"ANALYZE" helps you to find the right plan according to the number of rows got selected. I don't think, "ANALYZE" take care of updating the index entries. I might be wrong here, hope someone will give you better information. Thanks, Dinesh manojadinesh.blogspot.com On Fri, Oct 18, 2013 at 1:13 AM, AI Rumman <rumman...@gmail.com> wrote: > Hi, > > I have a very basic question. > If I create index concurrently, then do I need to analyze the table? If > yes, when? > Please let me know. > > Thanks. > >
