Re: Index Backward Scan fast / Index Scan slow !

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Index Backward Scan fast / Index Scan slow !
Дата
Msg-id 22096.1081864031@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Index Backward Scan fast / Index Scan slow !  (Pailloncy Jean-Gérard <pailloncy@ifrance.com>)
Список 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

В списке pgsql-performance по дате отправления:

Предыдущее
От: Pailloncy Jean-Gérard
Дата:
Сообщение: Re: Index Backward Scan fast / Index Scan slow !
Следующее
От: Rajesh Kumar Mallah
Дата:
Сообщение: Re: Deleting certain duplicates