Amazon Redshift’s UDF
Bence Faludi

Thanks for the great write-up on UDFs in Redshift Bence. Have you tried DISTSTYLE ALL for your small join table?

The default DISTSTYLE is EVEN which would be counterproductive for a small join table and would incur unnecessary shuffling and network I/O.

Have you tested on a single-node or multi-node dc1 (SSD) cluster?

Like what you read? Give Gabor Ratky a round of applause.

From a quick cheer to a standing ovation, clap to show how much you enjoyed this story.