Re: Proposal to introduce a shuffle function to intarray extension

On 7/15/22 04:36, Martin Kalcher wrote:
> Dear list,
>
> i am dealing with an application that processes fairly large arrays of
> integers. It makes heavy use of the intarray extension, which works
> great in most cases. However, there are two requirements that cannot
> be addressed by the extension and are rather slow with plain SQL. Both
> can be met with shuffling:
>
> - Taking n random members from an integer array
> - Splitting an array into n chunks, where each member is assigned to a
> random chunk
>
> Shuffling is currently implemented by unnesting the array, ordering
> the members by random() and aggregating them again.

Martin, have you considered PL/Python and NumPy module?

--
Mladen Gogala
Database Consultant
Tel: (347) 321-1217
https://dbwhisperer.wordpress.com