Running analysis as part of a stored proc

From: Ioannis Anagnostopoulos <ioannis(at)anatec(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: Running analysis as part of a stored proc
Date: 2012-07-28 19:19:22
Message-ID: 50143B3A.40408@anatec.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Is it advisable to include a VACUUM ANALYZE <table name> within a stored
procedure that runs as part of a batch every night?

Kind regards
Yiannis

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Tom Lane 2012-07-28 20:00:58 Re: Running analysis as part of a stored proc
Previous Message Tom Lane 2012-07-27 16:22:43 Re: problem with pg_dump