Re: Index speeds up one row table (why)? - Mailing list pgsql-bugs

From Bruno Wolff III
Subject Re: Index speeds up one row table (why)?
Date
Msg-id 20030531132403.GB31995@wolff.to
Whole thread Raw
In response to Index speeds up one row table (why)?  (Dave E Martin XXIII <postgresql-to.dave@dave.to>)
Responses Re: Index speeds up one row table (why)?  (Tom Lane <tgl@sss.pgh.pa.us>)
List 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.

pgsql-bugs by date:

Previous
From: Dave E Martin XXIII
Date:
Subject: Index speeds up one row table (why)?
Next
From: Stephan Szabo
Date:
Subject: Re: Index speeds up one row table (why)?