X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id AFF98D1B55E for ; Mon, 26 Apr 2004 14:21:00 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 40197-10 for ; Mon, 26 Apr 2004 14:20:59 -0300 (ADT) Received: from mail.astudios.com (ns1.astudios.com [66.49.77.3]) by svr1.postgresql.org (Postfix) with ESMTP id 2457ED1B47F for ; Mon, 26 Apr 2004 14:20:58 -0300 (ADT) thread-index: AcQrs1J3TY2Q3ehWSlu3D9wgKvl1cw== Content-Class: urn:content-classes:message Importance: normal X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.132 Received: from [10.4.2.156] ([66.194.26.150]) by mail.astudios.com with Microsoft SMTPSVC(6.0.3790.0); Mon, 26 Apr 2004 13:24:25 -0400 From: "Chris Hoover" To: "Tom Lane" Subject: Re: Help with performance problems Date: Mon, 26 Apr 2004 13:20:56 -0400 User-Agent: KMail/1.6.1 Cc: References: <200404230931.17850.revoohc@sermonaudio.com> <6865.1082775504@sss.pgh.pa.us> In-Reply-To: <6865.1082775504@sss.pgh.pa.us> MIME-Version: 1.0 Content-Disposition: inline Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Message-ID: <200404261320.56455.revoohc@sermonaudio.com> X-OriginalArrivalTime: 26 Apr 2004 17:24:25.0406 (UTC) FILETIME=[525B1DE0:01C42BB3] X-Virus-Scanned: by amavisd-new at postgresql.org X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests= X-Spam-Level: X-Archive-Number: 200404/445 X-Sequence-Number: 6745 Ok, I was able to run a vacuumdb -f -v on my largest db over the weekend.= =20=20 However, I am having trouble reading the results of the table portion. Her= e=20 area a couple of tables, what should I be looking at. First table is the k= ey=20 table to the db, and the second is the largest table in the db.=20=20 Thanks Chris INFO: --Relation public.clmhdr-- INFO: Pages 32191: Changed 0, reaped 5357, Empty 0, New 0; Tup 339351: Vac= =20 48358, Keep/VTL 0/0, UnUsed 129, MinLen 560, MaxLen 696; Re-using: Free/Av ail. Space 42011004/32546120; EndEmpty/Avail. Pages 0/5310. CPU 0.53s/0.09u sec elapsed 0.61 sec. INFO: Index clmhdr_pkey: Pages 1429; Tuples 339351: Deleted 48358. CPU 0.06s/0.28u sec elapsed 4.54 sec. INFO: Index clmhdr_hdr_user_id_idx: Pages 1711; Tuples 339351: Deleted 483= 58. CPU 0.09s/0.31u sec elapsed 2.40 sec. INFO: Index clmhdr_hdr_clm_status_idx: Pages 1237; Tuples 339351: Deleted= =20 48358. CPU 0.03s/0.26u sec elapsed 1.66 sec. INFO: Index clmhdr_hdr_create_dt_idx: Pages 1475; Tuples 339351: Deleted= =20 48358. CPU 0.05s/0.24u sec elapsed 1.96 sec. INFO: Index clmhdr_inv_idx: Pages 1429; Tuples 339351: Deleted 48358. CPU 0.08s/0.22u sec elapsed 1.20 sec. INFO: Index clmhdr_userid_status_idx: Pages 2161; Tuples 339351: Deleted= =20 48358. CPU 0.05s/0.18u sec elapsed 3.02 sec. INFO: Rel clmhdr: Pages: 32191 --> 28247; Tuple(s) moved: 8257. CPU 0.37s/1.81u sec elapsed 16.24 sec. INFO: Index clmhdr_pkey: Pages 1429; Tuples 339351: Deleted 8257. CPU 0.00s/0.03u sec elapsed 0.03 sec. INFO: Index clmhdr_hdr_user_id_idx: Pages 1743; Tuples 339351: Deleted 825= 7. CPU 0.00s/0.05u sec elapsed 0.04 sec. INFO: Index clmhdr_hdr_clm_status_idx: Pages 1265; Tuples 339351: Deleted= =20 8257. CPU 0.00s/0.04u sec elapsed 0.03 sec. INFO: Index clmhdr_hdr_create_dt_idx: Pages 1503; Tuples 339351: Deleted= =20 8257. CPU 0.00s/0.04u sec elapsed 0.12 sec. INFO: Index clmhdr_inv_idx: Pages 1429; Tuples 339351: Deleted 8257. CPU 0.00s/0.04u sec elapsed 0.03 sec. INFO: Index clmhdr_userid_status_idx: Pages 2203; Tuples 339351: Deleted= =20 8257. CPU 0.01s/0.03u sec elapsed 0.04 sec. INFO: --Relation public.sent837-- INFO: Pages 463552: Changed 0, reaped 6690, Empty 0, New 0; Tup 27431539: = Vac=20 204348, Keep/VTL 0/0, UnUsed 2801, MinLen 107, MaxLen 347; Re-using:=20 Free/Avail. Space 54541468/34925860; EndEmpty/Avail. Pages 0/70583. CPU 10.68s/2.18u sec elapsed 188.32 sec. INFO: Index sent837_pkey: Pages 124424; Tuples 27431539: Deleted 204348. CPU 4.24s/3.45u sec elapsed 144.79 sec. INFO: Rel sent837: Pages: 463552 --> 459954; Tuple(s) moved: 91775. CPU 1.12s/9.36u sec elapsed 20.13 sec. INFO: Index sent837_pkey: Pages 124424; Tuples 27431539: Deleted 91775. CPU 3.51s/2.03u sec elapsed 6.13 sec.