----- Original Message ----
> From: Jean-Michel Pouré <jm@xxxxxxxxx>
> To: pgsql-general@xxxxxxxxxxxxxx
> Sent: Monday, January 7, 2008 11:06:09 AM
> Subject: PhpBB 3.x query review
>
>
> I set indexes on ban_email, ban_userid and ban_ip.
> But the query plan is still the same.
>
> Any idea?
>
There is hardly any data in the table (~133 rows per page by my calculation) so the planner is choosing
to do a direct sequential scan instead of using an indirect lookup through an
index because it is faster. Considering the query returned in under 0.1ms I think you may be engaging in premature optimization by adding indexes to this table. If you expect that table to eventually contain many thousands of entries then an index might be prudent.
Regards,
Shelby Cain
____________________________________________________________________________________
Be a better friend, newshound, and
know-it-all with Yahoo! Mobile. Try it now. http://mobile.yahoo.com/;_ylt=Ahu06i62sR8HDtDypao8Wcj9tAcJ
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
