From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
---|---|
To: | Przemyslaw Kowalczyk (by way of Przemyslaw Kowalczyk <przemyslaw(dot)kowalczyk(at)engine(dot)com(dot)pl>) <przemyslaw(dot)kowalczyk(at)engine(dot)com(dot)pl> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Problem with indexes |
Date: | 2001-12-11 15:02:58 |
Message-ID: | 16054.1008082978@sss.pgh.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Przemyslaw Kowalczyk <przemyslaw(dot)kowalczyk(at)engine(dot)com(dot)pl> (by way of Przemyslaw Kowalczyk <przemyslaw(dot)kowalczyk(at)engine(dot)com(dot)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
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2001-12-11 15:25:43 | Re: bug or my ignorance ? |
Previous Message | Holger Krug | 2001-12-11 14:51:50 | Re: bug or my ignorance ? |