|author||Yorhel <firstname.lastname@example.org>||2020-04-05 15:18:05 +0200|
|committer||Yorhel <email@example.com>||2020-04-05 15:18:27 +0200|
SQL: Add C-based "vndbid" type and use it for image IDs
I had already rambled on the current composite type solution in 583ae868dfd3c882a8d2dd40b5d5ed099170c1c2 and I had already explored a few alternatives. This was the one alternative I hadn't yet explored because I wasn't sure the operational complexity was going to be worth it, but after seeing how bad PostgreSQL was at optimizing queries with composite types, I figured I might as well just go with this approach. It improves performance of some queries by a *lot* (especially the image selection query) and it's pretty elegant and convenient to work with. Only downside is the complexity of compiling, installing and maintaining a vndbid.so library for PostgreSQL.
Diffstat (limited to '.gitignore')
1 files changed, 3 insertions, 0 deletions
@@ -29,3 +29,6 @@