analyze at startup? - Mailing list pgsql-general

From Surabhi Ahuja
Subject analyze at startup?
Date
Msg-id CE5C48E227F8ED4990FAC4332100ADC621B535@EVS.iiitb.ac.in
Whole thread Raw
Responses Re: analyze at startup?
Re: analyze at startup?
List pgsql-general

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.

Thank You
Surabhi

pgsql-general by date:

Previous
From: Martijn van Oosterhout
Date:
Subject: Re: numeric precision when raising one numeric to another.
Next
From: Richard Huxton
Date:
Subject: Re: analyze at startup?