some reading for better understanding of postgresql
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