analyze at startup?

From: "Surabhi Ahuja " <surabhi(dot)ahuja(at)iiitb(dot)ac(dot)in>
To: <pgsql-general(at)postgresql(dot)org>
Subject: analyze at startup?
Date: 2005-05-19 10:20:07
Message-ID: CE5C48E227F8ED4990FAC4332100ADC621B535@EVS.iiitb.ac.in
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Richard Huxton 2005-05-19 10:37:10 Re: analyze at startup?
Previous Message Martijn van Oosterhout 2005-05-19 09:14:06 Re: numeric precision when raising one numeric to another.