Today, Mattias|farm on IRC asked how to create primary key using HASH index. After some talk, he said that in some books it said that for "=" (equality) hash indexes are better. So, I digged a bit deeper.

Every now and then there is someone on IRC, mailing lists, or private contact which asks about rules. My answer virtually always is: don't use rules. If you think that they solve your problem, think again. Why?

On 3rd of August, Tatsuo Ishii committed patch by ITAGAKI Takahiro: Log Message: ----------- Multi-threaded version of pgbench contributed by ITAGAKI Takahiro, reviewed by Greg Smith and Josh Williams.   Following is the proposal from ITAGAKI Takahiro:   Pgbench is a famous tool to measure postgres performance, but ...

couple of times is was brought to attention of #postgresql channel - how to find longest prefix. case: you have phone number, and you want to find which carrier it is bound to. there are at least 3 ways of finding it, ...