Przemyslaw Kowalczyk <przemyslaw.kowalczyk@engine.com.pl> (by way of Przemyslaw Kowalczyk
<przemyslaw.kowalczyk@engine.com.pl>)writes:
> stats=# explain SELECT ip FROM log WHERE date = 1000733984 ;
> NOTICE: QUERY PLAN:
> Seq Scan on log (cost=0.00..52859.15 rows=9008 width=12)
(1) a VACUUM ANALYZE seems called for;
(2) what is the datatype of the date column? If it's not int4 then you
may need to quote or cast the constant.
regards, tom lane