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

On 3rd of November Andrew Dunstan committed his patch which adds new function to PostgreSQL - suppress_redundant_updates_trigger(). This function is not for using in selects, but it can help you tremendously if your database access matches certain pattern.

When I was working for one of customers we found some strange thing. We needed to found number of distinct sessions per day. Table layout was very simple:

as you perhaps know there is this site/blog called high scalability. it contains articles about various things related to performance, scalability, availability and so on. usually, when there is something about databases, it is about mysql. luckily for us, today they ...