I had two month delay related to some work, but now I can finally write about: On 7th of December, Robert Haas committed patch: Implement table partitioning. Table partitioning is like table inheritance and reuses much of the existing infrastructure, but there are some ...

Some time ago, guys from Instagram shared their approach to generating unique ids on multiple hosts in a way that guarantees (to reasonable extend) uniqueness, and doesn't require any centralized service. Earlier this month, the build benchmarked their solution vs. UUIDs, ...

The general knowledge is that numerics are slower than integers/float, but offer precision and ranges that are better. While I understand what is slow, I don't really know how much slower numerics are. So let's test it.

When working with PostgreSQL you generally want to get information about slow queries. The usual approach is to set log_min_duration_statement to some low(ish) value, run your app, and then analyze logs. But you can log to many places - flat file, ...

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, ...