Need indexes on empty tables for good performance ?

From: "Lenard, Rohan (Rohan)" <rlenard(at)avaya(dot)com>
To: <pgsql-performance(at)postgresql(dot)org>
Subject: Need indexes on empty tables for good performance ?
Date: 2005-08-23 03:41:32
Message-ID: 2773CAC687FD5F4689F526998C7E4E5F43F392@au3010avexu1.global.avaya.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

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

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Tom Lane 2005-08-23 04:42:09 Re: unused item pointers?
Previous Message Alan Stange 2005-08-23 02:51:28 unused item pointers?