Get the latest tech news
What I wish someone told me about Postgres
I’ve been working professionally for the better part of a decade on web apps and, in that time, I’ve had to learn how to use a lot of different systems and tools. During that education, I found that the official documentation typically proved to be the most helpful.
An index is a data structure intended to help with looking up data–giving Postgres the responsibility of maintaining a “shortcut directory” to a table’s rows by various fields. You can imagine how this can lead to all kinds of scenarios where clients are holding onto locks for much longer than they need, preventing others from successfully making queries against or updates to the database. In many ways, it makes Postgres have all the strengths of a document-oriented database(like MongoDB, for example) without having to spin up a new service or coordinate between two different data stores.
Or read this on Hacker News