Re: [HACKERS] Optimizer is fixed, and faster
От | Bruce Momjian |
---|---|
Тема | Re: [HACKERS] Optimizer is fixed, and faster |
Дата | |
Msg-id | 199902150237.VAA22396@candle.pha.pa.us обсуждение исходный текст |
Ответ на | Re: [HACKERS] Optimizer is fixed, and faster (Vadim Mikheev <vadim@krs.ru>) |
Список | pgsql-hackers |
> Bruce Momjian wrote: > > > > This is exactly what I need. My testing is very limited. I basically > > test the functionality, but not real-world samples. I am still working. > > I will let everyone know when I am done, and you can throw any queries > > at it. > > > > Was there a speedup with the new optimizer? Was the new plan faster? > > The new optimizer uses 'cost' much more reliably. I hope our cost > > estimates for various join types is accurate. > ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ > No. It's ok for netsloop only. That is bad. Can you tell someone how to compute those, so perhaps they can give us accurate numbers. -- 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, Pennsylvania19026
В списке pgsql-hackers по дате отправления: