Viewing profile — feike

pgbackrest is the most versatile piece of backup technology for PostgreSQL and in my experience the other products do not come close. I am therefore quite sad to see this happen. I…

As every year, I try to solve it with 1 sql statement for every challenge, https://gitlab.com/feike/adventofcode/-/tree/master/2024 , likely going to get stuck again around day 12/…

Many libraries for python, Rust, golang support COPY BINARY. The times I've tested it, the improvement is very small as compared to plain copy, or copy with CSV, whereas it does re…

Timescaler here, if you configure the timescaledb.compress_segmentby well, and the data suits the compression, you can achieve 20x or more compression. (On some metrics data intern…

You should be able nowadays with PG16 INSERT INTO tbl1 VALUES ($1, $2) \bind 'first value' 'second value' \g https://www.postgresql.org/docs/current/app-psql.html#APP-PS... For old…

You can put it upright on a piano and put sheet music at eye level. I personally use flowkey + an electrical piano connected through USB. Beats a tablet for me!

PostgreSQL has used this term for decades! The oldest I can find is from 1998 (PostgreSQL 6.3), but it was probably in use even before. > Postgres offers substantial additional pow…

The trust is not just banning unsafe, it is using a limited std: > The "trusted" version of PL/Rust uses a unique fork of Rust's std entitled postgrestd when compiling LANGUAGE plr…

Just did a sequential run (to get some better measurements), and this is an excerpt of the things happening in the PostgreSQL instance inside the Docker container, for creating and…

We do this too for PostgreSQL: to ensure the tests are really fast: - we create a template database using the migrations - for *every* integration test we do `CREATE DATABASE test1…

If you keep reading, the words following your quote make it clear that PG15 should be supported: "and will support PostgreSQL 13 and all the future releases of PostgreSQL."

A single query can write to multiple tables, using CTE's in PostgreSQL for example. You could compose a SQL query that allows you to map multiple resultsets to 1 resultset, althoug…

Reminds me of Markus Winand who hands out stickers on database conferences banning offset. His site is a great resource for anyone wanting to take a deeper dive on SQL performance:…

You can use regexes to help you split the file into pieces (this is in PostgreSQL), I expect other dbms's to have similar functions available. SELECT lineno::int AS line, ((lineno-…

Shameless plug, I've been doing this (without much success after day 8 or so) for a couple of years now. My rules are: - 1 statement per part - No schema needed https://gitlab.com/…

Patroni does have synchronous_mode_strict setting, which may be what you're looking for: This parameter prevents Patroni from switching off the synchronous replication on the prima…

This postgresql mailing list thread allows you to read along with the PostgreSQL developers and Jepsen, seems like a very useful discussion: https://www.postgresql.org/message-id/f…

> Can Patroni tell if master node is not responsive because it is busy vs dead No. But the contract Patroni has is this: I only serve a master (primary) if I have the lock. If I do…

One of the authors of Patroni here. Automatic failover for PostgreSQL works great and can be done safely if combined with synchronous replication. Multiple tools will implement thi…

I've been doing this by having a single SQL statement per puzzle. Didn't get beyond day 7 last year, but so far so good: https://gitlab.com/feike/adventofcode/tree/master/2019

Good set of tips, however "Not NOT IN" is not true in general, as a single counterexample: EXPLAIN (costs off) SELECT relname, relpages FROM pg_class WHERE relname IN ('pg_class');…

I was at the presentation last Thursday, they (OnGres) have fully open sourced both their methodology and their results and had a pretty strict divide between teams designing the b…