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
EMAIL PROTECTED] Sent: Tuesday, August 30, 2005 6:15
AMTo: Lenard, Rohan (Rohan)Cc:
pgsql-performance@postgresql.orgSubject: Re: [PERFORM] Need indexes
on empty tables for good performance ?
Rohan,
You should note that in Postgres, indexes are not inherited by child
tables.
Als
