Em 24/07/2012 18:23, John R Pierce escreveu:
On 07/24/12 2:15 PM, François Beausoleil wrote:
Le 2012-07-24 à 16:36, Edson Richter a écrit :
>I know PostgreSQL from time to time runs automatically the vacuum
process.
>My applications grows due lots of data import during the day (about
100Mb/day).
>Do I need also to schedule a Vacuum Analyze to happens from time to
time?
I already asked that question for 9.1
here:http://dba.stackexchange.com/questions/18664/are-regular-vacuum-analyze-stil-recommended-under-9-1
autovacuum does analyze as it goes.
Thanks, that was the missing point :-)
Regards,
Edson
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general