3 ms·
There's also no word about indexing or analysis (and postgres is very sensitive to having up-to-date statistics). And on sqlite you might be leaving memory / s
by masklinn 4y ago
There's also no word about indexing or analysis (and postgres is very sensitive to having up-to-date statistics).
And on sqlite you might be leaving memory / storage on the table if you use a UUID as PK and don't remove the implicit ROWID.
- miguelgrinberg 4y agoI did not feel that was a relevant topic for this article. I have spent a good amount of time over the life of this application optimizing indexes, though. But the article is about how I designed a test to benchmark these two databases, not a general discussion on all the optimizations you can make.
- phibz 4y agoIn postgres there usually no good reason to use varchar unless you specifically want to enforce size limits. If you don't care use TEXT, the performance is the same.