Re: Query to find contiguous ranges on a column - Mailing list pgsql-general

From Peter Hunsberger
Subject Re: Query to find contiguous ranges on a column
Date
Msg-id cc159a4a0910141503n4a665536s9fe114afae150958@mail.gmail.com
Whole thread Raw
In response to Re: Query to find contiguous ranges on a column  (Tim Landscheidt <tim@tim-landscheidt.de>)
List pgsql-general
On Wed, Oct 14, 2009 at 4:50 PM, Tim Landscheidt <tim@tim-landscheidt.de> wrote:
> Peter Hunsberger <peter.hunsberger@gmail.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

pgsql-general by date:

Previous
From: "Naoko Reeves"
Date:
Subject: how to Export ALL plpgsql functions/triggers to file
Next
From: Christophe Pettus
Date:
Subject: SFPUG: Video from "Statistics and Postgres -- How the Planner Sees Your Data" Now on Vimeo