Re: Pg 9.1: Do I need to run vacuum analyze instead vacuum full?

From: François Beausoleil <francois(at)teksol(dot)info>
To: Edson Richter <edsonrichter(at)hotmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Pg 9.1: Do I need to run vacuum analyze instead vacuum full?
Date: 2012-07-24 21:15:16
Message-ID: 5A6D72D2-EA28-43E6-8740-08AF19CC3F48@teksol.info
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


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

Bye!
François

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message John R Pierce 2012-07-24 21:22:15 Re: insert binary data into a table column with psql
Previous Message Edson Richter 2012-07-24 20:36:09 Pg 9.1: Do I need to run vacuum analyze instead vacuum full?