Horton

Re: Index speeds up one row table (why)?

Bruno Wolff III <bruno@wolff.to>

View thread
From: Bruno Wolff III <bruno@wolff.to>
To: Dave E Martin XXIII <postgresql-to.dave@dave.to>
Cc: pgsql-bugs@postgresql.org
Date: 2003-05-31T13:24:03Z
Lists: pgsql-bugs 
On Sat, May 31, 2003 at 00:14:18 -0600,
  Dave E Martin XXIII <postgresql-to.dave@dave.to> wrote:
> version: 7.3.2
> 
> Currently this table has one row in it, where name is 15 unicode 
> characters long. It would seem that there would be no need for an index 
> on name. However, doing:

It probably has one visible row in it. If it can changed a lot, there
may be lots of deleted tuples in a row. That would explain why an
index scan speeds things up.