Re: index v. seqscan for certain values

Поиск
Список
Период
Сортировка
От Manfred Koizar
Тема Re: index v. seqscan for certain values
Дата
Msg-id 571u701m7fkc97oi1ul8qfuf8e94kvi8lg@email.aon.at
обсуждение исходный текст
Ответ на Re: index v. seqscan for certain values  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-performance
On Tue, 13 Apr 2004 13:55:49 -0400, Tom Lane <tgl@sss.pgh.pa.us> wrote:
>Possibly the
>nonuniform clumping of CID has something to do with the poor results.

It shouldn't.  The sampling algorithm is designed to give each tuple the
same chance of ending up in the sample, and tuples are selected
independently.  (IOW each one of the {N \chooose n} possible samples has
the same probability.)   There are known problems with nonuniform
distribution of dead vs. live and large vs. small tuples, but AFAICS the
order of values does not matter.

Servus
 Manfred

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: PostgreSQL and Linux 2.6 kernel.
Следующее
От: Manfred Koizar
Дата:
Сообщение: Re: query slows down with more accurate stats