Re: Query to find contiguous ranges on a column

From: Peter Hunsberger <peter(dot)hunsberger(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Query to find contiguous ranges on a column
Date: 2009-10-14 22:03:26
Message-ID: cc159a4a0910141503n4a665536s9fe114afae150958@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Wed, Oct 14, 2009 at 4:50 PM, Tim Landscheidt <tim(at)tim-landscheidt(dot)de> wrote:
> Peter Hunsberger <peter(dot)hunsberger(at)gmail(dot)com> wrote:
>
> After some tests with a data set of 7983 rows (and 1638 ran-
> ges): Don't! :-) The recursive solution seems to be more
> than double as slow as the iterative. I'll take it to -per-
> formance.
>

Interesting, I've never liked recursive on Oracle but performance is
usually reasonable... Thanks for the heads up...

--
Peter Hunsberger

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Christophe Pettus 2009-10-14 22:53:33 SFPUG: Video from "Statistics and Postgres -- How the Planner Sees Your Data" Now on Vimeo
Previous Message Naoko Reeves 2009-10-14 21:59:29 how to Export ALL plpgsql functions/triggers to file