3 ms·
> In general, RDBMSs start shedding performance the more non-integer columns you have in your relevant tables. The more non-integer indexes, I'd suggest. Time
by Jedd 8y ago
> In general, RDBMSs start shedding performance the more non-integer columns you have in your relevant tables.
The more non-integer indexes, I'd suggest.
TimescaleDB under Postrgres goes a long way to improving scaling of certain (NoSQL-type content) large databases.
- squirrelicus 8y agoI think we're both right for sure, but even just having varchars in your critical join tables is a big perf killer given there'll be fewer rows read per page fault(unless you're just index scanning/joining of course)