diff options
| author | Yorhel <git@yorhel.nl> | 2021-02-24 09:46:03 +0100 |
|---|---|---|
| committer | Yorhel <git@yorhel.nl> | 2021-02-24 10:25:45 +0100 |
| commit | 530a9a65f90001678f3340dff5edc155cafec827 (patch) | |
| tree | 19ba3be50554c5b02df9aa24da0f231b4c7c2e22 /README.md | |
| parent | 30070e326f18789f8b82252090b269166d5ade22 (diff) | |
SQL/vndbid: Add HASHES & MERGES options to eq operator + equalimage btree function
The HASHES and MERGES options enable some pretty important join
strategies, amazing how I haven't stumbled upon major performance issues
before without them.
The equalimage function enables btree key deduplication in Postgres 13+.
Won't have a major impact on performance, but still a nice to have.
I don't have a migration script for these changes, it'll involve
updating all existing columns and indices that use the vndbid type. I'll
instead work on a script to dump all data and use the sql/ files to
re-import everything. Been wanting such a script for a while, anyway.
Diffstat (limited to 'README.md')
| -rw-r--r-- | README.md | 2 |
1 files changed, 1 insertions, 1 deletions
@@ -65,7 +65,7 @@ Global requirements: - Linux, or an OS that resembles Linux. Chances are VNDB won't run on Windows. - A standard C build system (make/gcc/etc) -- PostgreSQL 10+ (including development files) +- PostgreSQL 13+ (including development files) - Perl 5.26+ - Elm 0.19.1 - Graphviz |