Re: Query to find contiguous ranges on a column

Поиск
Список
Период
Сортировка
От Peter Hunsberger
Тема Re: Query to find contiguous ranges on a column
Дата
Msg-id cc159a4a0910141503n4a665536s9fe114afae150958@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Query to find contiguous ranges on a column  (Tim Landscheidt <tim@tim-landscheidt.de>)
Список 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 по дате отправления:

Предыдущее
От: "Naoko Reeves"
Дата:
Сообщение: how to Export ALL plpgsql functions/triggers to file
Следующее
От: Christophe Pettus
Дата:
Сообщение: SFPUG: Video from "Statistics and Postgres -- How the Planner Sees Your Data" Now on Vimeo