Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id CB7BA475FD4 for ; Thu, 12 Dec 2002 09:11:28 -0500 (EST) Received: from acheron.rime.com.au (unknown [203.208.66.49]) by postgresql.org (Postfix) with ESMTP id 1F555475F3D for ; Thu, 12 Dec 2002 09:11:28 -0500 (EST) Received: from localhost (localhost [127.0.0.1]) by acheron.rime.com.au (Postfix on SuSE Linux 8.0 (i386)) with ESMTP id 3CCEC54598; Fri, 13 Dec 2002 01:11:31 +1100 (EST) Received: by acheron.rime.com.au (Postfix on SuSE Linux 8.0 (i386), from userid 527) id 37F4554599; Fri, 13 Dec 2002 01:11:30 +1100 (EST) Received: from hephaestus.rhyme.com.au (unknown [203.8.195.124]) by acheron.rime.com.au (Postfix on SuSE Linux 8.0 (i386)) with ESMTP id AFF6A54598; Fri, 13 Dec 2002 01:11:29 +1100 (EST) Message-Id: <5.1.0.14.0.20021213010808.060da928@mail.rhyme.com.au> X-Sender: pjw@mail.rhyme.com.au X-Mailer: QUALCOMM Windows Eudora Version 5.1 Date: Fri, 13 Dec 2002 01:09:41 +1100 To: =?iso-8859-1?Q?H=E9ctor?= Iturre , LISTA DE POSTGRES From: Philip Warner Subject: Re: Performance Problems In-Reply-To: <20021212125615.23571.qmail@web20108.mail.yahoo.com> Mime-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1"; format=flowed Content-Transfer-Encoding: quoted-printable X-Spam-Status: No, hits=-3.1 required=8.5 tests=IN_REP_TO,WEIRD_PORT version=2.31 X-Spam-Level: X-Virus-Scanned: by AMaViS 0.3.12pre8 X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200212/156 X-Sequence-Number: 10744 At 09:56 AM 12/12/2002 -0300, H=E9ctor Iturre wrote: > I 've >perform severals VACUMM on the database with poor >results. Have you done an ANALYZE? Which version of PG are you using? Can you send output from VACUUM VERBOSE ? ---------------------------------------------------------------- Philip Warner | __---_____ Albatross Consulting Pty. Ltd. |----/ - \ (A.B.N. 75 008 659 498) | /(@) ______---_ Tel: (+61) 0500 83 82 81 | _________ \ Fax: (+61) 03 5330 3172 | ___________ | Http://www.rhyme.com.au | / \| | --________-- PGP key available upon request, | / and from pgp5.ai.mit.edu:11371 |/