<psql(at)elbrief(dot)de> wrote:
> In my live environment i have a table with a boolean where the
> boolean is usually true. The boolean is false on new or changed
> entrys and if i select the false-rows order by primary key i get
> slow querys. The table has a lot of million rows and a very small
> amount of rows with false.
That sure sounds like a situation where you should use a partial
index.
http://www.postgresql.org/docs/current/interactive/indexes-partial.html
-Kevin