Re: DB Tuning Notes for comment...

Philip Warner <pjw@rhyme.com.au> writes:
> At 03:54 PM 9/12/2002 -0500, Tom Lane wrote:
>> FSM entries aren't needed for sequences either, so more correct is
>> 
>> select count(*) from pg_class where relkind in ('r', 't');

> presumably:

>       select count(*) from pg_class where relkind in ('r', 't', 'i');

No, I meant what I said.  Indexes don't use the FSM.  (The premise of
the FSM is that one bit of free space in a table is as good as any other
bit; a premise quite incorrect for indexes.)
        regards, tom lane