Postgres Pro
Downloads
Home   >   mailing lists

Auto Vacuum Daemon - Mailing list pgsql-general

From
Subject Auto Vacuum Daemon
Date
Msg-id 4AD2336877609F41A2B0D53BAD09FC57B2974A@VOO-EXCHANGE07.internal.sungard.corp
Whole thread Raw
Responses Re: Auto Vacuum Daemon  (Rikard Bosnjakovic <rikard.bosnjakovic@gmail.com>)
Re: Auto Vacuum Daemon  (Scott Marlowe <scott.marlowe@gmail.com>)
List pgsql-general
Tree view

Hello All,

 

I am using Postgres 8.3.5 on windows and was using manually VACCUM and ANALYZE commands in my scripts but now I have turned on the AutoVaccum daemon by changing the postgresql conf file.

 

Is it fine to do that or should we manually perform vacuum and analyze.

Will it automatically take care of vacuuming the tables and analyzing them?

 

Any suggestions will be appreciated.

 

Thanks & Regards

__________________________________________________________________________________________________________________________________

Ambarish Bhattacharya | Senior Software Engineer | SunGard Technology Services | Meridian Plaza, Sr.No.108/8/1+2/1, S B Road | Pune 411053, India |

| Tel: +91-20-25606232    | Mobile: +91 9823964376  | A.Bhattacharya@sungard.com  | www.sungard.com |

 

P Think before you print

CONFIDENTIALITY: This email (including any attachments) may contain confidential, proprietary and privileged information, and unauthorized disclosure or use is prohibited. If you received this email in error, please notify the sender and delete this email from your system. Thank you.

 

 

 

pgsql-general by date:

Previous
From: Grzegorz Jaśkiewicz
Date:
Subject: Re: quote string exactly as it is
Next
From: Merlin Moncure
Date:
Subject: Re: quote string exactly as it is