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 по дате отправления: