Evgeniy DeminKill Indexes of Nulls“Adding an index is a simple solution,” — they say. It is simple, but there is something you should do first.Jan 2, 2023Jan 2, 2023
Evgeniy DeminHash 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!Dec 24, 2022Dec 24, 2022
Evgeniy DeminPostgreSQL: 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.Dec 19, 2022Dec 19, 2022
Evgeniy DeminPostgreSQL 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.Dec 14, 2022A response icon3Dec 14, 2022A response icon3
