Analyze command helps increase performance. Suppose i have n connections to the database..and each connection i query. So does this mean that i need to do an analyse over each of those connections.
Cant analyze be done one time... and also please tell if there is any way in postgresql to tell it to perform analyze periodically after some time gap.