> 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
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.
In response to
pgsql-performance by date
|Next:||From: Andrus||Date: 2006-06-09 09:40:26|
|Subject: Re: Why date index is not used|
|Previous:||From: Christopher Kings-Lynne||Date: 2006-06-09 01:19:15|
|Subject: Re: Regarding pg_dump utility|