Blogで使うSQL
SELECT DISTINCT ARRAY_TO_STRING(ARRAY(SELECT category_name FROM category WHERE category.entry_id = e.entry_id ORDER BY category_order ASC), ',') AS category
FROM entry AS e
ORDER BY category
がPostgreSQLだと30msでYugabyteだと5sかかる。Yugabyteが苦手なクエリなのかな
posted at 17:05:23