Hi, I have about 6 tables that inherit from one table. They all have the exact same indexes but when i try to query all by a row (which is indexed, btree) the QP decides to do sequential scan for some of them (the bigger tables) rather than use the index. Any ideas why that may happen? I am using postgres 8.2 Thanks, S.
---------------------------(end of broadcast)--------------------------- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq