Re: [HACKERS] TODO list updated

[Charset iso-8859-1 unsupported, filtering to ASCII...]
> > -----Original Message-----
> > From: Bruce Momjian [mailto:pgman(at)candle(dot)pha(dot)pa(dot)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(at)candle(dot)pha(dot)pa(dot)us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026