Re: Cool hack with recursive queries - Mailing list pgsql-hackers

From David Fetter
Subject Re: Cool hack with recursive queries
Date
Msg-id 20081121210504.GA31533@fetter.org
Whole thread Raw
In response to Re: Cool hack with recursive queries  (Zdenek Kotala <Zdenek.Kotala@Sun.COM>)
Responses Re: Cool hack with recursive queries  (Tom Lane <tgl@sss.pgh.pa.us>)
List 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 by date:

Previous
From: Tom Lane
Date:
Subject: Re: HEAD build failure on win32 mingw
Next
From: Tom Lane
Date:
Subject: Re: Cool hack with recursive queries