Received: from localhost (maia-2.hub.org [200.46.204.187])
	by postgresql.org (Postfix) with ESMTP id C9C719FB412
	for <pgsql-performance-postgresql.org@postgresql.org>;
	Fri, 12 Jan 2007 05:07:54 -0400 (AST)
Received: from postgresql.org ([200.46.204.71])
	by localhost (mx1.hub.org [200.46.204.187]) (amavisd-new, port 10024)
	with ESMTP id 96419-01-2
	for <pgsql-performance-postgresql.org@postgresql.org>;
	Fri, 12 Jan 2007 05:07:39 -0400 (AST)
X-Greylist: from auto-whitelisted by SQLgrey-1.7.4
Received: from lynet.oppetid.no (oppetid.no [80.65.51.2])
	by postgresql.org (Postfix) with ESMTP id 3BB5B9FBDDD
	for <pgsql-performance@postgresql.org>;
	Fri, 12 Jan 2007 05:05:01 -0400 (AST)
Received: by lynet.oppetid.no (Postfix, from userid 1019)
	id EC32C11AF0B; Fri, 12 Jan 2007 10:05:00 +0100 (CET)
Date: Fri, 12 Jan 2007 10:05:00 +0100
From: Tobias Brox <tobias@nordicbet.com>
To: Peter Childs <peterachilds@gmail.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: Planner statistics, correlations
Message-ID: <20070112090500.GB16243@oppetid.no>
References: <20070112081631.GA10636@oppetid.no>
	<a2de01dd0701120056p37f1906excd71068468e5769a@mail.gmail.com>
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
In-Reply-To: <a2de01dd0701120056p37f1906excd71068468e5769a@mail.gmail.com>
Organization: Group Nordicbet
User-Agent: Mutt/1.5.9i
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Archive-Number: 200701/199
X-Sequence-Number: 22800

[Peter Childs - Fri at 08:56:54AM +0000]
> Can you say what state might be rather than what it is not. I'm guess
> that state is an int but there is only a limited list of possible
> states, if you can say what it might be rather than what it is the
> index is more liklly to be used.

  explain select * from events where state in (1,2,3) and event_time<now()

also estimates almost 5k of rows.  I also tried:

  explain select * from events where state=2 and event_time<now()

but get the same behaviour.

Maybe it would help to partitionate the table every year?