Re: when do I analyze after concurrent index creation?

[dinesh kumar <dineshkumar02@xxxxxxxxx>]

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 <rummandba@xxxxxxxxx> 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.