X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id A44D753E17 for ; Thu, 21 Apr 2005 14:01:20 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 34735-02 for ; Thu, 21 Apr 2005 17:01:15 +0000 (GMT) Received: from smtp-relay.bart.gov (smtp-relay.bart.gov [206.169.110.100]) by svr1.postgresql.org (Postfix) with ESMTP id C503153A56 for ; Thu, 21 Apr 2005 14:01:11 -0300 (ADT) Received: from surfnotes-c01.adm.bart.gov (itmailgw2 [148.165.126.193]) by smtp-relay.bart.gov (8.12.2+Sun/8.12.2) with ESMTP id j3LH1Bp1024504 for ; Thu, 21 Apr 2005 10:01:11 -0700 (PDT) X-SEF-C34810F9-4E7A-4641-937D-965A5F898B4: 1 Received: from Unknown [148.165.126.191] by surfnotes-c01.adm.bart.gov - SurfControl E-mail Filter (5.0); Thu, 21 Apr 2005 10:02:15 -0700 Received: from csekcopley2 ([148.165.2.11]) by notes-c01.bart.gov (Lotus Domino Release 6.5.3) with SMTP id 2005042110021445-3590 ; Thu, 21 Apr 2005 10:02:14 -0700 Message-ID: <003301c5469b$eead09c0$0b02a594@csekcopley2> From: "Kevin Copley" To: Subject: vacuumdb -v output Date: Thu, 21 Apr 2005 10:59:54 -0700 MIME-Version: 1.0 X-Priority: 3 (Normal) X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2800.1409 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1409 X-MIMETrack: Itemize by SMTP Server on Notes-C01/BART(Release 6.5.3|September 14, 2004) at 04/21/2005 10:02:14 AM, Serialize by Router on Notes-C01/BART(Release 6.5.3|September 14, 2004) at 04/21/2005 10:02:15 AM, Serialize complete at 04/21/2005 10:02:15 AM Content-Type: multipart/alternative; boundary="--=_NextPart_ST_10_02_15_Thursday_April_21_2005_6363" X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.163 tagged_above=0 required=5 tests=HTML_30_40, HTML_MESSAGE, MIME_BOUND_NEXTPART X-Spam-Level: X-Archive-Number: 200504/303 X-Sequence-Number: 17316 This is a multi-part message in MIME format. ----=_NextPart_ST_10_02_15_Thursday_April_21_2005_6363 Content-Transfer-Encoding: quoted-printable Content-Type: text/plain; charset="iso-8859-1" Hi,=0D=0AI've just put a system into production in which some tables are up= dated frequently - several times per second.=0D=0AI'm doing a nightly vacuu= mdb -v, but am not sure if it's achieving anything. Here's the output for o= ne table:=0D=0A=0D=0A------------------------------------------------------= ---------------------------------------------------------------------------= -------------------=0D=0AINFO: vacuuming "public.fip_track_circuit"=0D=0AI= NFO: index "fip_track_circuit_pk" now contains 1557427 row versions in 453= 8 pages=0D=0ADETAIL: 10 index row versions were removed.=0D=0A0 index page= s have been deleted, 0 are currently reusable.=0D=0ACPU 0.22s/0.14u sec ela= psed 6.51 sec.=0D=0AINFO: "fip_track_circuit": removed 10 row versions in = 9 pages=0D=0ADETAIL: CPU 0.00s/0.00u sec elapsed 0.00 sec.=0D=0AINFO: "fi= p_track_circuit": found 10 removable, 1557427 nonremovable row versions in = 14305 pages=0D=0ADETAIL: 1555321 dead row versions cannot be removed yet.=0D= =0AThere were 1 unused item pointers.=0D=0A0 pages are entirely empty.=0D=0A= CPU 0.42s/0.24u sec elapsed 6.82 sec.=0D=0AINFO: vacuuming "public.fip_xl_= switch"=0D=0A--------------------------------------------------------------= ---------------------------------------------------------------------------= -----------=0D=0A=0D=0AI'm concerned about ".... 1555321 dead row versions = cannot be removed yet...."=0D=0A=0D=0AI'd be extremely grateful if anyone c= ould cast some light on this.=0D=0AThanks, Kevin=0D=0A=0D=0A ----=_NextPart_ST_10_02_15_Thursday_April_21_2005_6363 Content-Transfer-Encoding: quoted-printable Content-Type: text/html; charset="iso-8859-1" =0D=0A<= HEAD>=0D=0A=0D=0A=0D= =0A=0D=0A=0D=0A=0D=0A
Hi,
=0D=0A
I've just put a system into production in which=20=0D=0Asome tables ar= e updated frequently - several times per second.
=0D=0A
I'm doing a nightly vacuumdb -v, but am not sure i= f=20=0D=0Ait's achieving anything. Here's the output for one table:<= /DIV>=0D=0A
 
=0D=0A
<= FONT face=3DArial=20=0D=0Asize=3D2>----------------------------------------= ---------------------------------------------------------------------------= ---------------------------------
=0D=0A
INFO:  vacuuming=20=0D=0A"public.fip_track_circuit"
INFO:=   index "fip_track_circuit_pk" now=20=0D=0Acontains 1557427 row versio= ns in 4538 pages
DETAIL:  10 index row=20=0D=0Aversions were remove= d.
0 index pages have been deleted, 0 are currently=20=0D=0Areusable.CPU 0.22s/0.14u sec elapsed 6.51 sec.
INFO: =20=0D=0A"fip_track_ci= rcuit": removed 10 row versions in 9 pages
DETAIL:  CPU=20=0D=0A0.0= 0s/0.00u sec elapsed 0.00 sec.
INFO:  "fip_track_circuit": found 10= =20=0D=0Aremovable, 1557427 nonremovable row versions in 14305 pages
DET= AIL: =20=0D=0A1555321 dead row versions cannot be removed yet.
Ther= e were 1 unused item=20=0D=0Apointers.
0 pages are entirely empty.
CP= U 0.42s/0.24u sec elapsed 6.82=20=0D=0Asec.
INFO:  vacuuming "publi= c.fip_xl_switch"
=0D=0A--------------------------------------= ---------------------------------------------------------------------------= -----------------------------------
=0D=0A
 
=0D=0A=
I'm concerned about ".... 1555321 dead row versions cannot be removed =0D= =0Ayet...."
=0D=0A
 
=0D=0A
I'd be extremely gratefu= l if anyone could cast some light on this.
=0D=0A
Thanks, Kevin
=0D=0A
 
=0D=0A ----=_NextPart_ST_10_02_15_Thursday_April_21_2005_6363--