We feature a lot of articles about using Postgres, sometimes some about the community, but rarely a look at the code underneath that powers the database we love. Here’s a great inspection of some of the Postgres core code.
Postgres supports a number of index types, though hash indexes come with a big warning on the box. So why do they even exist? They can yield some extra performance in certain cases as demonstrated here, but use them in production at your own risk.
Accelerate your learning with training taught by Postgres Community Leader Bruce Momjian. Designed for database professionals responsible for administration and maintenance of PostgreSQL. Increase proficiency and learn best practices. Space is limited – sign up today.
Spawned in part by an email response on the pgsql-hackers list that read “Yeha!”… this followup patch greatly reduces certain cases where full table vacuums are needed. The short of this means the impact of vacuum wraparound is greatly reduced.
Indeed Prime is an elite new program from Indeed.com that presents
in-demand tech talent like you to top employers. Indeed Prime opens
the door to exciting career opportunities with one simple application.