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

From: Bruno Wolff III <bruno(at)wolff(dot)to>
To: Dave E Martin XXIII <postgresql-to(dot)dave(at)dave(dot)to>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: Index speeds up one row table (why)?
Date: 2003-05-31 13:24:03
Message-ID: 20030531132403.GB31995@wolff.to
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

On Sat, May 31, 2003 at 00:14:18 -0600,
Dave E Martin XXIII <postgresql-to(dot)dave(at)dave(dot)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.

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Stephan Szabo 2003-05-31 15:19:20 Re: Index speeds up one row table (why)?
Previous Message Dave E Martin XXIII 2003-05-31 06:14:18 Index speeds up one row table (why)?