Manfred Koizar wrote:
> On Sun, 7 Sep 2003 11:43:42 -0400 (EDT), Bruce Momjian
> <[EMAIL PROTECTED]> wrote:
> >I assume this completes this TODO:
> >
> >     * Order duplicate index entries by tid for faster heap lookups
> I don't think so, because the patch does nothing to keep the sort
> order once the index is initially created.

As Tom mentioned, we might not want to keep the tid's in order after the
index is created because he wants the most recent tid's first, so the
expired ones migrate to the end.

Seems this patch does what we want currently because it only affects the
initial index structure.

> > If you want to post it now, [...]
> I did already post it.  It's only the last page or so of the original
> message.  The link in that message points to a testing aid which is
> not part of what I would like to see committed.

OK, in 7.5 queue:


  Bruce Momjian                        |
  [EMAIL PROTECTED]               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073

---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
      joining column's datatypes do not match

Reply via email to