X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id 40481D1CCA8 for ; Thu, 5 Feb 2004 18:50:37 +0000 (GMT) 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 26377-06 for ; Thu, 5 Feb 2004 14:50:34 -0400 (AST) Received: from mailr-1.tiscali.it (mailr-1.tiscali.it [212.123.84.81]) by svr1.postgresql.org (Postfix) with ESMTP id D4E44D1CCA6 for ; Thu, 5 Feb 2004 14:50:31 -0400 (AST) Received: from ppp-82-84-56-186.cust-adsl.tiscali.it (HELO alphaville) (82.84.56.186) by mailr-1.tiscali.it with ESMTP; 05 Feb 2004 19:50:31 +0100 Message-Id: <2s28b9$l9kbu@mailr-1.tiscali.it> X-BrightmailFiltered: true Reply-To: From: "Edoardo Ceccarelli" To: "'Sam Barnett-Cormack'" , "'Edoardo Ceccarelli'" Cc: "'David F. Skoll'" , Subject: R: R: R: slow seqscan after vacuum analize Date: Thu, 5 Feb 2004 19:50:31 +0100 Organization: expot.it MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable X-Mailer: Microsoft Office Outlook, Build 11.0.5510 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1106 Thread-Index: AcPr+XzRYKo4K5pERiKwhihheqYGGwAH05HA In-Reply-To: X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200402/89 X-Sequence-Number: 12263 Well, maybe it was more, can't remember, it was at 3am! :)=20 > -----Messaggio originale----- > Da: pgsql-admin-owner@postgresql.org=20 > [mailto:pgsql-admin-owner@postgresql.org] Per conto di Sam=20 > Barnett-Cormack > Inviato: gioved=EC 5 febbraio 2004 16.00 > A: Edoardo Ceccarelli > Cc: 'David F. Skoll'; pgsql-admin@postgresql.org > Oggetto: Re: R: R: [ADMIN] slow seqscan after vacuum analize >=20 > On Thu, 5 Feb 2004, Edoardo Ceccarelli wrote: >=20 > > after a VACUUM FULL ANALYZE (1h!!) things are ok >=20 > Only a hour - lucky you ;) >=20 > --=20 >=20 > Sam Barnett-Cormack > Software Developer | Student of=20 > Physics & Maths > UK Mirror Service (http://www.mirror.ac.uk) | Lancaster University >=20 > ---------------------------(end of=20 > broadcast)--------------------------- > TIP 5: Have you checked our extensive FAQ? >=20 > http://www.postgresql.org/docs/faqs/FAQ.html >=20 >=20