Postgres Pro
Downloads
Home   >   mailing lists

Re: when do I analyze after concurrent index creation? - Mailing list pgsql-general

From dinesh kumar
Subject Re: when do I analyze after concurrent index creation?
Date
Msg-id CALnrH7oSiXQcBGRrD6c+NErykb_zkHEDKMD3CaG2KmwEcxWmbA@mail.gmail.com
Whole thread Raw
In response to when do I analyze after concurrent index creation?  (AI Rumman <rummandba@gmail.com>)
Responses Re: when do I analyze after concurrent index creation?
List pgsql-general
Tree view
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



On Fri, Oct 18, 2013 at 1:13 AM, AI Rumman <rummandba@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. 


pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: How do I create a box from fields in a table?
Next
From: Tom Lane
Date:
Subject: Re: when do I analyze after concurrent index creation?