To colleagues and friends at SUSE, 5 years later

I’ve been thinking about what to write here, and anything that came to my mind was boring – how cool those 5 years were for me, what projects I have accomplished, how many lines of code I wrote, what I have in mind for the future… Me, myself, I and politically correct corporate yadda yadda anniversary yadda yadda.

Who cares about this stuff?

Ultimately I decided to abandon the anniversary theme completely, instead taking the chance to send messages out to a few of you, my dear colleagues and friends.

Read On…

A Postgres deadlock bug case study

This is the third post in a small series dedicated to analysing and dealing with deadlocks in PostgreSQL, and provides a real bugfixing case study. Check the first article for an introduction and the second one for guidelines and techniques.

This post describes how I attempted fixing a real deadlock bug in SUSE Manager, which is also affecting the Spacewalk project it’s based upon. Hopefully it will shed light to someone fixing a similar issue!

Read On…

Postgres deadlocks debugging guidelines, tips and tricks

This is the second post in a small series dedicated to analysing and dealing with deadlocks in PostgreSQL, and provides a general workflow to handle deadlock bugs and details on how to get information from PostgresSQL.

If you need a gentler introduction, take a look at the first article in this series.

Debugging a deadlock – a workflow

If you have to deal with a deadlock in a complex application, usually you’ll have a defect that appears in time-dependent, load-dependent and user-dependent way. It’s all too easy to get lost in hypotheses! To avoid that try to work in a scientific way and follow a strategy.

Read On…

Deadlocks in Postgres 101

This is the first post in a small series dedicated to analysing and dealing with deadlocks in PostgreSQL, and provides a rather gentle introduction to the topic.

What is a deadlock?

A deadlock is a situation in which a DBMS cannot execute all concurrent transactions running in a specific point in time. It must, and it will, automatically kill some of them in order to complete others.

Read On…

30 Aprile: presentazione su idee e tecnologie Apple

Lunedì prossimo 30 Aprile tengo una presentazione presso il gruppo CodeLovers sulle idee “fuori dal coro” dietro alcune delle tecnologie Apple. Sarà un incontro molto tecnico, rivolto essenzialmente ai programmatori (della Mela e non).

L’incontro è aperto a tutti e gratuito, alle 21:00 allo Spazio Polaresco di Longuelo.

Per maggiori informazioni rimando al blog dei CodeLovers.

A presto!