Re: Problem with indexes

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: Whole Thread | Raw Message | 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

In response to

Browse pgsql-general by date

  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 ?