Re: Index Tuning Features - Mailing list pgsql-hackers

From Florian Weimer
Subject Re: Index Tuning Features
Date
Msg-id 82iriq82ka.fsf@mid.bfk.de
Whole thread Raw
In response to Re: Index Tuning Features  (Andrew Sullivan <ajs@crankycanuck.ca>)
Responses Hints (Was: Index Tuning Features)  (Andrew Sullivan <ajs@crankycanuck.ca>)
List pgsql-hackers
* Andrew Sullivan:

> Just because I'm one of those statistics true believers, what sort of
> information do you think it is possible for the DBA to take into
> consideration, when building a hint, that could not in principle be
> gathered efficiently by a statistics system?

Some statistics are very hard to gather from a sample, e.g. the number
of distinct values in a column.

-- 
Florian Weimer                <fweimer@bfk.de>
BFK edv-consulting GmbH       http://www.bfk.de/
Durlacher Allee 47            tel: +49-721-96201-1
D-76131 Karlsruhe             fax: +49-721-96201-99


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: Hints WAS: Index Tuning Features
Next
From: Teodor Sigaev
Date:
Subject: Re: Patch for Win32 blocking problem