Every story and comment from the Hacker News API, in a layout borrowed from 2001.
A comment on Pleroma 2.0: a free, federated social networking server built on open protocols. Parent comment
https://shon.github.io/2015/12/21/postgres_array_performance...
https://gist.github.com/joevandyk/031cf5812bd656887623
To search for a post with multiple tags, you need to do a join for each tag. You don't have that problem with arrays.
https://shon.github.io/2015/12/21/postgres_array_performance...
https://gist.github.com/joevandyk/031cf5812bd656887623
To search for a post with multiple tags, you need to do a join for each tag. You don't have that problem with arrays.