Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
Re: Why date index is not used
- From: "Andrus" <eetasoft(at)online(dot)ee>
- To: pgsql-performance(at)postgresql(dot)org
- Subject: Re: Why date index is not used
- Date: Fri, 9 Jun 2006 12:06:47 +0300
> Btw. have you run ANALYZE on the table recently? I have autovacuum with default statitics settings running so I expect that it is analyzed. > What is the number > of distinct values in the 'kuupaev' column? select count(distinct kuupaev) from makse returns 61 kuupaev is sales date. So this can contain 365 distinct values per year and max 10 year database, total can be 3650 distinct values after 10 years. Andrus
- References:
- Why date index is not used
- From: Andrus
- Re: Why date index is not used
- From: Tomas Vondra
- Why date index is not used
- Prev by Date: Re: Regarding pg_dump utility
- Next by Date: Re: Why date index is not used
- Previous by thread: Re: Why date index is not used
- Next by thread: Re: Why date index is not used
- Indexes: