"Chris Hoover" <revoohc@xxxxxxxxx> writes: > Is it better to create 3 indexes, or one index on the three columns? This is covered in considerable detail in the fine manual: http://www.postgresql.org/docs/8.2/static/indexes.html See particularly sections 11.3 and 11.4 regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend