Postgres Pro
Downloads
Home   >   mailing lists

Re: VACUUM FULL on 24/7 server - Mailing list pgsql-general

From Tom Lane
Subject Re: VACUUM FULL on 24/7 server
Date
Msg-id 26607.1096758925@sss.pgh.pa.us
Whole thread Raw
In response to VACUUM FULL on 24/7 server  (Aleksey Serba <aserba@gmail.com>)
List pgsql-general
Tree view 
Aleksey Serba <aserba@gmail.com> writes:
>    I have 24/7 production server under high load.
>    I need to perform vacuum full on several tables to recover disk
>    space / memory  usage frequently ( the server must be online during
> vacuum time )

Don't use VACUUM FULL; plain VACUUM should be enough if you are managing
the database properly (for instance, make sure the FSM settings are high
enough).

            regards, tom lane

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: earthdistance is not giving correct results.
Next
From: Michael Fuhr
Date:
Subject: Re: earthdistance is not giving correct results.