Deriv Tech blog
Sign in Subscribe

database

A collection of 3 posts
Parallel query without parallel query
database

Parallel query without parallel query

One of the key improvements since Postgres 9.6 has been the ability to distribute a query to multiple worker processes. Yet, with a few tricks this has been feasible almost forever, at least for the really heavy stuff. I prefer to keep the database specific stuff in the database
May 10, 2019 8 min read
Lock contention in PostgreSQL
database

Lock contention in PostgreSQL

At deriv.com, our clients can trade in binary options. We keep all the related information in a PostgreSQL database. The life cycle of such an option begins when it is bought by a client. In our language, this is called an open position. Later the client sells the position
Feb 7, 2019 6 min read
How to use EXPLAIN output in PostgreSQL?
postgresql

How to use EXPLAIN output in PostgreSQL?

Sometimes you want to process the EXPLAIN output in SQL. Unfortunately, EXPLAIN itself does not offer that option. However, there are tricks... Wrapping EXPLAIN in a function This is probably the simpler version. It requires to create a function: CREATE OR REPLACE FUNCTION explain( p_q TEXT, p_mod TEXT[
Apr 27, 2018 1 min read
Page 1 of 1
Deriv Tech blog © 2023
  • About
  • Careers
  • LinkedIn
  • GitHub
Powered by Ghost