Evgeniy Demin·Jan 2, 2023Kill Indexes of Nulls“Adding an index is a simple solution,” — they say. It is simple, but there is something you should do first.
Evgeniy Demin·Dec 24, 2022Hash index: to be, or not to be?This single SQL query can help you find B-Tree indexes that may become Hash indexes saving you money on storage bills!
Evgeniy Demin·Dec 19, 2022PostgreSQL: Analyze it first!I recently wrote an article about comparing Hash and B-tree indexes. Unfortunately, I made a mistake, and now it’s time to make it right.
Evgeniy Demin·Dec 14, 2022PostgreSQL indexes: Hash vs B-treeDo you always know when to use the hash index over the b-tree index? How significant would the benefit be from the choice? I don’t.A response icon3A response icon3
