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 6F049D1D26C for ; Mon, 12 Apr 2004 18:24:31 -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 89033-06 for ; Mon, 12 Apr 2004 18:24:32 -0300 (ADT) Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by svr1.postgresql.org (Postfix) with ESMTP id 9297CD1D1C4 for ; Mon, 12 Apr 2004 18:24:23 -0300 (ADT) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.12.11/8.12.11) with ESMTP id i3CLNkjT013961; Mon, 12 Apr 2004 17:23:47 -0400 (EDT) To: =?ISO-8859-1?Q?Pailloncy_Jean-G=E9rard?= Cc: pgsql-performance@postgresql.org Subject: Re: Index Backward Scan fast / Index Scan slow ! In-reply-to: References: <8A2105D4-8C63-11D8-80FD-000A95DE2550@ifrance.com> <8579.1081772899@sss.pgh.pa.us> Comments: In-reply-to =?ISO-8859-1?Q?Pailloncy_Jean-G=E9rard?= message dated "Mon, 12 Apr 2004 21:02:02 +0200" Date: Mon, 12 Apr 2004 17:23:46 -0400 Message-ID: <13960.1081805026@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200404/143 X-Sequence-Number: 6443 [ Ah, I just got to your message with the VACUUM VERBOSE results ... ] =?ISO-8859-1?Q?Pailloncy_Jean-G=E9rard?= writes: > dps=# VACUUM VERBOSE url; > INFO: index "url_next_index_time" now contains 349519 row versions in > 3534 pages > DETAIL: 229515 index row versions were removed. > 3071 index pages have been deleted, 2864 are currently reusable. > CPU 0.32s/0.67u sec elapsed 76.25 sec. Hm, this is odd. That says you've got 349519 live index entries in only 463 actively-used index pages, or an average of 754 per page, which AFAICS could not fit in an 8K page. Are you using a nondefault value of BLCKSZ? If so what? If you *are* using default BLCKSZ then this index must be corrupt, and what you probably need to do is REINDEX it. But before you do that, could you send me a copy of the index file? regards, tom lane