Courses in Databases

I was preparing a post about what can slow down a query, but when I was reading a lot of different stuff online to make sure I am writing truth I encountered several interesting papers, and presentations that I think are worth reading. First of them is a series of presentations regarding Data Processing on ...

In-Memory Bitmap Index in Postgres

I have written twice already that bitmap indexes are not implemented in Postgres. But somebody may as why then explain writes that it used Bitmap Index Scan? However, that is not on-disk index I wrote about. One of the most interesting analysis of performance I found is at Depesz.com, which is a blog of a Polish database ...

FiFO with SQL

I am going to create small system/website that will allow me to manage my stocks, and monitor the portfolio. I do not have much of it, but I cannot access the data from wherever I want and it is not so dynamic. Beside the design itself I came across a problem of recreating a FIFO ...

PostgreSQL 9.3

I did not realize that on my brithday PostgreSQL hit 9.3 mark (see a news). With this release there is a new join type that I first hear about. It is named LATERAL JOIN. There is no need for me to copy the documentation, so if you want to know what that is head to ...