Re: Index Backward Scan fast / Index Scan slow !

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Pailloncy Jean-Gérard <pailloncy(at)ifrance(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Index Backward Scan fast / Index Scan slow !
Date: 2004-04-13 13:47:11
Message-ID: 22096.1081864031@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

=?ISO-8859-1?Q?Pailloncy_Jean-G=E9rard?= <pailloncy(at)ifrance(dot)com> writes:
>> Are you using a nondefault value of
>> BLCKSZ? If so what?

> Sorry, I forgot to specify I use BLCKSZ of 32768,

Okay, the numbers are sensible then. The index density seems a bit low
(754 entries/page where the theoretical ideal would be about 1365) but
not really out-of-line.

>> could you send me a copy of the index file?

> Do you want the index file now, or may I try something before?

If you're going to reindex, please do send me a copy of the file first.

regards, tom lane

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Rajesh Kumar Mallah 2004-04-13 14:27:01 Re: Deleting certain duplicates
Previous Message Pailloncy Jean-Gérard 2004-04-13 11:12:36 Re: Index Backward Scan fast / Index Scan slow !