| From: | David Fetter <david(at)fetter(dot)org> |
|---|---|
| To: | Zdenek Kotala <Zdenek(dot)Kotala(at)Sun(dot)COM> |
| Cc: | Alvaro Herrera <alvherre(at)commandprompt(dot)com>, David Rowley <dgrowley(at)gmail(dot)com>, 'Gregory Stark' <stark(at)enterprisedb(dot)com>, 'Postgres' <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: Cool hack with recursive queries |
| Date: | 2008-11-21 21:05:04 |
| Message-ID: | 20081121210504.GA31533@fetter.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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(at)fetter(dot)org> http://fetter.org/
Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter
Skype: davidfetter XMPP: david(dot)fetter(at)gmail(dot)com
Remember to vote!
Consider donating to Postgres: http://www.postgresql.org/about/donate
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2008-11-21 21:11:11 | Re: Cool hack with recursive queries |
| Previous Message | Tom Lane | 2008-11-21 20:52:42 | Re: HEAD build failure on win32 mingw |