Re: INDEX suggestion needed

On Thu, 12 Dec 2002 15:33:11 +0100, Thomas Beutin
<tyrone(at)laokoon(dot)IN-Berlin(dot)DE> wrote:
> AND ( visit >= '2002-12-01' OR visit <= '2002-12-11');
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
This is logically equivalent to (visit IS NOT NULL), I guess you want
AND, not OR.

> -> Seq Scan on stat_pages (cost=0.00..13821.19 rows=343520 width=34)
>
>Is there any hope left? ;-)

Please show us the output of
VACUUM VERBOSE ANALYZE stat_pages;

EXPLAIN ANALYZE
SELECT COUNT(DISTINCT a_id)
FROM stat_pages
WHERE m_id = 35::smallint
AND (visit >= '2002-12-01' AND visit <= '2002-12-11');

SELECT attname, null_frac, avg_width, n_distinct,
most_common_vals, histogram_bounds, correlation
FROM pg_stats
WHERE tablename = 'stat_pages'
AND attname IN ('m_id', 'visit');

Servus
Manfred