Re: Index Backward Scan fast / Index Scan slow ! - Mailing list pgsql-performance

=?ISO-8859-1?Q?Pailloncy_Jean-G=E9rard?= <pailloncy@ifrance.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