I've read that
indexes aren't used for COUNT(*) and I've noticed (7.3.x) with EXPLAIN that
indexes never seem to be used on empty tables - is there any reason to have
indexes on empty tables, or will postgresql never use them.
This is not as silly
as it sounds - with table inheritance you might have table children with the
data and a parent that is empty. It'd be nice to make sure postgresql
knows to never really look at the parent - especially is you don't know the
names of all the children ..
Thoughts
?
thx,
Rohan
