Re: [HACKERS] TODO list updated

[Charset iso-8859-1 unsupported, filtering to ASCII...]
> > -----Original Message-----
> > From: Bruce Momjian [mailto:pgman@candle.pha.pa.us]
> >
> > > Hmmm,who solved ????
> > > * -spinlock stuck problem when elog(FATAL) and elog(ERROR) inside bufmgr
> >
> > I thought you or Tatsuo fixed that.  I will remove the mark.
> >
> 
> I have had a fix for it for 3 months but not committed because I don't
> know how WAL would change it.
> OK I would commit it after some checking.

Ah, so my memory isn't that bad.  WAL is not going into 7.0, so it
should be fine.

> > We currently do not use indexes to handle ORDER BY because it is slower,
> > but for queries returning only a few rows, we could use the index and
> > skip the ORDER BY.  Not sure if this is done yet, or if it is important.
> >
> 
> Tom has changed to take IndexScan into account even when no qual exists.
> * -Allow optimizer to prefer plans that match ORDER BY(Tom)
> Currently optimizer is too eager to use index scan. He is planning to take
> limit into account AFAIK,  He has mentioned it many times and I have been
> looking forward to his change.

OK, TODO updated.

-- 
  Bruce Momjian                        |  http://www.op.net/~candle
  maillist@candle.pha.pa.us            |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026