Re: PostGreSQL and recursive queries...

From: Andrew Dunstan <andrew(at)dunslane(dot)net>
To: Hubert FONGARNAND <informatique(dot)internet(at)fiducial(dot)fr>
Cc: "pgsql-hackers(at)postgresql(dot)org" <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: PostGreSQL and recursive queries...
Date: 2007-11-27 15:00:35
Message-ID: 474C3113.50905@dunslane.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hubert FONGARNAND wrote:
> We are using the CONNECT BY patch made by Evgen Potemkin on
> PostGreSQL 8.2... It works like a charm with very high performances.
>
> But now, we are looking for the 8.3 release... Evgen Potemkin has
> stopped to answer about this patch (it's quite normal, he's working at
> mysql now...). I've tried to port the patch to the 8.3 postgresql
> version... It compiles but it segfault. Many data structures have
> changed between 8.3 and 8.2 and i'm not aware enough of postgresql
> internals...
>
> So, now the solutions :
>
> * using the connectby C function... which is min 10x slower
> than the patch (we may improve it a bit, but i doubt it'd beat
> the patch...)
> * Waiting for the WITH RECURSIVE support for the 8.4 (but i
> don't expect anything, because this is on the todo list since
> many years, and i'ven't seen any code/patch since)
> * Someone help me to get the patch working on the 8.3
> * moving to oracle..... :-(((( or another hierarchical aware
> database.
>
>
> It's hard to explain to our manager that if we move to the next version
> of postgresql there will be a performance drop.
>
> What is the best solution
> Please help me!!!
>
>
>

If you are unable to get the patch working with 8.3 yourself, you can
sponsor or employ someone to do it for you, or to get WITH RECURSIVE
done for 8.4, which would solve the problem forever, or maybe even both
would be worth doing.

cheers

andrew

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Gregory Stark 2007-11-27 15:21:48 Re: PostGreSQL and recursive queries...
Previous Message Martijn van Oosterhout 2007-11-27 14:58:48 Re: String encoding during connection "handshake"