some reading for better understanding of postgresql

  • April 16, 2016

Today nothing big, just that I have a couple of links open on my firefox, that I plan to read when I have sometimes to learn more about postgresql, So here we are:

Learning more about the search engine integrated in it:

These articles are pretty complete and start by assuming you know nothing It’s also a good read if you just want to know how search engine are implemented in general.

Some deep analysis on how to improve distinct count by group:

And an article about using partial indexes:

And one about understanding how to read and understand the EXPLAIN