Home > mailing lists

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

From	AI Rumman
Subject	when do I analyze after concurrent index creation?
Date	October 17, 2013 22:44:00
Msg-id	CAGoODpd09iVw289B1pxt8U6PBtZe+y5yfR4gGCmdAAhMoe13VQ@mail.gmail.com Whole thread Raw
Responses	Re: when do I analyze after concurrent index creation? (dinesh kumar <dineshkumar02@gmail.com>)
List	pgsql-general

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.

From: Kevin Grittner
Date: 17 October 2013, 22:37:46
Subject: Re: Index creation fails with automatic names

From: Tomas Vondra
Date: 17 October 2013, 23:40:59
Subject: Re: Need some help on Performance 9.0.4