Re: index v. seqscan for certain values - Mailing list pgsql-performance

From Manfred Koizar
Subject Re: index v. seqscan for certain values
Date
Msg-id 571u701m7fkc97oi1ul8qfuf8e94kvi8lg@email.aon.at
Whole thread Raw
In response to Re: index v. seqscan for certain values  (Tom Lane <tgl@sss.pgh.pa.us>)
List 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 by date:

Previous
From: Tom Lane
Date:
Subject: Re: PostgreSQL and Linux 2.6 kernel.
Next
From: Manfred Koizar
Date:
Subject: Re: query slows down with more accurate stats