Postgres Pro
Downloads
Home   >   mailing lists

Re: Pg 9.1: Do I need to run vacuum analyze instead vacuum full? - Mailing list pgsql-general

From François Beausoleil
Subject Re: Pg 9.1: Do I need to run vacuum analyze instead vacuum full?
Date
Msg-id 5A6D72D2-EA28-43E6-8740-08AF19CC3F48@teksol.info
Whole thread Raw
In response to Pg 9.1: Do I need to run vacuum analyze instead vacuum full?  (Edson Richter <edsonrichter@hotmail.com>)
Responses Re: Pg 9.1: Do I need to run vacuum analyze instead vacuum full?  (John R Pierce <pierce@hogranch.com>)
Re: Pg 9.1: Do I need to run vacuum analyze instead vacuum full?  (Edson Richter <edsonrichter@hotmail.com>)
Re: Pg 9.1: Do I need to run vacuum analyze instead vacuum full?  (Edson Richter <edsonrichter@hotmail.com>)
List pgsql-general
Tree view 
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

pgsql-general by date:

Previous
From: jkells
Date:
Subject: insert binary data into a table column with psql
Next
From: John R Pierce
Date:
Subject: Re: insert binary data into a table column with psql