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.

One database that I am monitoring uses a lot of stored procedures. Some of them are fast, some of them are not so fast. I thought - is there a sensible way to diagnose which part of stored procedure take ...

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