Re: Why date index is not used - Mailing list pgsql-performance

From Andrus
Subject Re: Why date index is not used
Date
Msg-id e6bgd3$1vgk$1@news.hub.org
Whole thread Raw
In response to Why date index is not used  ("Andrus" <eetasoft@online.ee>)
List pgsql-performance
> 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



pgsql-performance by date:

Previous
From: Christopher Kings-Lynne
Date:
Subject: Re: Regarding pg_dump utility
Next
From: "Andrus"
Date:
Subject: Re: Why date index is not used