Re: Highly Efficient Custom Sorting - Mailing list pgsql-performance

From Eliot Gable
Subject Re: Highly Efficient Custom Sorting
Date
Msg-id AANLkTikJZvJ3v5nzLRSvXdVL3WUKOd6_qfUU4Re5Qp93@mail.gmail.com
Whole thread Raw
In response to Re: Highly Efficient Custom Sorting  (Joe Conway <mail@joeconway.com>)
Responses Re: Highly Efficient Custom Sorting
List pgsql-performance

On Tue, Jul 6, 2010 at 4:00 PM, Joe Conway <mail@joeconway.com> wrote:


This approach works, but you could also use the SFRM_Materialize mode
and calculate the entire result set in one go. That tends to be simpler.
See, for example crosstab_hash() in contrib/tablefunc for an example.

FWIW, there are also some good examples of array handling in PL/R, e.g.
pg_array_get_r() in pg_conversion.c


 Thanks. That looks like less code and probably will be slightly more efficient.

pgsql-performance by date:

Previous
From: Joe Conway
Date:
Subject: Re: Highly Efficient Custom Sorting
Next
From: Stephen Frost
Date:
Subject: Re: Question about partitioned query behavior