Re: Cool hack with recursive queries

Поиск
Список
Период
Сортировка
От David Fetter
Тема Re: Cool hack with recursive queries
Дата
Msg-id 20081121210504.GA31533@fetter.org
обсуждение исходный текст
Ответ на Re: Cool hack with recursive queries  (Zdenek Kotala <Zdenek.Kotala@Sun.COM>)
Ответы Re: Cool hack with recursive queries  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers
On Fri, Nov 21, 2008 at 09:06:13PM +0100, Zdenek Kotala wrote:
> Alvaro Herrera napsal(a):
>> David Fetter escribió:
>>> On Wed, Nov 19, 2008 at 10:21:06PM -0000, David Rowley wrote:
>>>> Gregory Stark wrote:
>>>>> So based on Graeme Job's T-SQL hack over at thedailywtf.com I
>>>>> adapted the T-SQL code to Postgres and got this. Thought others
>>>>> might find it amusing.
>>>>>
>>>> That's pretty amazing.
>>>>
>>>> I think we should add a regression test with that. :)
>>> +1 for adding a regression test :)
>>
>> It's too slow for that :-(
>
> I takes 2.6 second on my laptop. I think it is not so bad.

About 2.0 on my OS/X laptop.  Could this be a problem on whatever
architecture/OS/compiler combo you have?

Cheers,
David.
-- 
David Fetter <david@fetter.org> http://fetter.org/
Phone: +1 415 235 3778  AIM: dfetter666  Yahoo!: dfetter
Skype: davidfetter      XMPP: david.fetter@gmail.com

Remember to vote!
Consider donating to Postgres: http://www.postgresql.org/about/donate


В списке pgsql-hackers по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: HEAD build failure on win32 mingw
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Cool hack with recursive queries