Nikita Volkov bio photo

Nikita Volkov

Email Twitter LinkedIn Github Stackoverflow

This post is all about the performance of the “hasql” library and particularly its PostgreSQL back end in comparison to its popular direct competitors: “HDBC” and “postgresql-simple”.

Contents

Benchmarks

The source of the PostgreSQL back end comes with a suite of 3 benchmarks. I’ll analyze them one by one.

Results parsing

In this benchmark a simple SELECT query without any parameters is performed. This eliminates the overhead related to encoding of parameters and leaves us with execution of the query and decoding of its results. Decoding of results is actually what we’re trying to compare here.

And here are the results:

Results parsing (HTML version)

We see that Hasql is 2 times faster than “postgresql-simple” and 7 times faster than “HDBC”.

Templates and rendering

In this benchmark a SELECT query is performed as well. Only this time there are parameters to encode and no results get decoded. So, what we measure is how well the subject deals with rendering of parameters and queries.

Templates and rendering (HTML version)

We see that Hasql is 1.7 times faster than “postgresql-simple” and 2.8 times faster than “HDBC”.

Writing transaction

This is the most general benchmark. It includes both encoding and decoding on top of transaction mechanics. It simulates a bunch of transfers from one account to another.

Writing transaction (HTML version)

Here the difference is more subtle: Hasql is 1.26 times faster than “postgresql-simple” and 1.59 times faster than “HDBC”.

What makes Hasql so fast?

So we’ve seen that Hasql dominates in every case. There are fundamentally different design decisions from its competitors that cause this:

  • Unlike in “HDBC”, the front end API brings no intermediate types, which eradicates unneccessary conversions.

  • Unlike “postgresql-simple”, the library utilizes parametric queries instead of recompiling them for every value.

  • Unlike “postgresql-simple”, the library utilizes prepared statements, which allows the database to parse the SQL statements only once per connection.

  • Unlike both “HDBC” and “postgresql-simple”, the PostgreSQL back end of Hasql uses a binary format for communication, which eradicates a bunch of overhead related to parsing, rendering and transfering of values on both ends: the library and the database itself.