In the previous article, we discussed what is Indexing and why it is an important part of our Database. Now let’s see a practical example how efficiently created indexing can help us and how can we figure out the same.
Querying Postgres databases, when done properly, can result in extremely efficient results and provide powerful insights. Sometimes, however, queries are written in less than optimal ways, causing slow response times. Because of this, it is important to be able to analyze how queries execute and find the most optimized ways to run them.
One method for optimizing queries is to…
Indexing makes columns faster to query by creating pointers to where data is stored within a database.
Imagine you want to find a piece of information that is within a large database. To get this information out of the database the computer will look through every row until it finds it. If the data you are looking for is towards the very end, this query would take a long time to run.
Visualization for finding the last entry:
If the table was ordered alphabetically, searching for a name could happen a lot faster because we could skip looking for the…
What is Docker? What is the container?
Remember the old days when the developer’s favorite tool was SSH. We use to log in to the server using SSH and then pull our code using git and install all dependencies globally and then restart your application and server from the proxy, preferably Nginx. Everyone was happy. This setup probably worked for a long time, until it didn’t. Until some developer from your team relied upon another dependency and installed it on the production server and your service is down now. …
Elasticsearch is a distributed, free and open search and analytics engine for all types of data, including textual, numerical, geospatial, structured, and unstructured.
Elasticsearch allows you to store, search, and analyze huge volumes of data quickly and in near real-time and give back answers in milliseconds. It’s able to achieve fast search responses because instead of searching the text directly, it searches an index.
Elasticsearch is able to achieve fast search responses because, instead of searching the text directly, it searches an index instead.
This is like retrieving pages in a book related to a keyword by scanning…