This blog discusses the performance issues with wildcard lookups in YugabyteDB and showcases alternative methods to find specific data in a large dataset, including several varieties of phonetic matching and trigrams. A test plan is provided to demonstrate basic query timings.
In a distributed database, data is split into multiple tablets which reside on different nodes. So it is not just tables, but indexes, that are distributed across nodes. So let’s examine how to optimally design distributed indexes to get the best query performance.
Although most databases ship with a command line utility to administer the instance, these utilities often come with a steep learning curve. If using the command line and learning sometimes arcane syntax makes you uncomfortable, there are graphical tools that can help you speed up many daily DBA tasks. In fact, you can find a comprehensive list of tools on the PostgreSQL wiki here. In a previous blog we explored the DBeaver database management tool,
…