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: 2006-06-09 09:06:47
Message-ID: e6bgd3$1vgk$1@news.hub.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Andrus 2006-06-09 09:40:26 Re: Why date index is not used
Previous Message Christopher Kings-Lynne 2006-06-09 01:19:15 Re: Regarding pg_dump utility