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

From: Edson Richter <edsonrichter(at)hotmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Pg 9.1: Do I need to run vacuum analyze instead vacuum full?
Date: 2012-07-24 20:36:09
Message-ID: BLU0-SMTP2363745CA8291436AD7CF5BCFDC0@phx.gbl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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?

Edson

Responses

Browse pgsql-general by date

  From Date Subject
Next Message François Beausoleil 2012-07-24 21:15:16 Re: Pg 9.1: Do I need to run vacuum analyze instead vacuum full?
Previous Message jkells 2012-07-24 20:28:01 insert binary data into a table column with psql