Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id D8759476BB2 for ; Thu, 14 Nov 2002 15:37:16 -0500 (EST) Received: from mail.virginia.edu (mail.Virginia.EDU [128.143.2.9]) by postgresql.org (Postfix) with SMTP id ED816475F25 for ; Thu, 14 Nov 2002 15:37:11 -0500 (EST) Received: from smtp.mail.virginia.edu by mail.virginia.edu id ac09607; 14 Nov 2002 15:36 EST Received: from jlk3xpc (d-128-19-222.bootp.Virginia.EDU [128.143.19.222]) by smtp.mail.Virginia.EDU (8.11.6/8.11.6) with SMTP id gAEKasr45290 for ; Thu, 14 Nov 2002 15:36:54 -0500 Message-ID: <016e01c28c1d$f9db6340$de138f80@virginia.edu> From: Jodi Kanter To: Postgres Admin List Subject: VACUUM Date: Thu, 14 Nov 2002 15:39:45 -0500 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_0169_01C28BF4.0EF7B0F0" X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 5.50.4522.1200 X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4522.1200 X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200211/153 X-Sequence-Number: 6341 This is a multi-part message in MIME format. ------=_NextPart_000_0169_01C28BF4.0EF7B0F0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable I am trying to set up my cron job to run the appropriate vacuums on our dat= abase. I understand from reading the documentation that regular vacuums, va= cuum full, and vacuum analyze are all important. Can someone assist in tell= ing me what is the most efficient order? I would assume that analyze should= be done once the inaccessible rows are released within the table and then = to the OS? We currently have a small amount of data in our database so my plan was to = do all vacuums on the entire database.=20 Also, I read that reindexing was important. Does this need to be done as fr= equently as the vacuums? Is it only done on a per table basis? or can you r= eindex the entire database? Thanks Jodi _______________________________ Jodi L Kanter BioInformatics Database Administrator University of Virginia (434) 924-2846 jkanter@virginia.edu =20 =20 =20 ------=_NextPart_000_0169_01C28BF4.0EF7B0F0 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable

I am trying to set up my cron job to ru= n the=20 appropriate vacuums on our database. I understand from reading the document= ation=20 that regular vacuums, vacuum full, and vacuum analyze are all important. Ca= n=20 someone assist in telling me what is the most efficient order? I would assu= me=20 that analyze should be done once the inaccessible rows are released within = the=20 table and then to the OS?

We currently have a small amount of dat= a in=20 our database so my plan was to do all vacuums on the entire database.= =20

Also, I read that reindexing was import= ant.=20 Does this need to be done as frequently as the vacuums? Is it only done on = a per=20 table basis? or can you reindex the entire database?

Thanks

Jodi

_______________________________
Jodi=20 L Kanter
BioInformatics Database Administrator
University of=20 Virginia
(434) 924-2846
jkanter@virginia.edu

<= /DIV> ------=_NextPart_000_0169_01C28BF4.0EF7B0F0--