feike

7 ms·

1.
by feike 5mo ago
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. It won't be easy to get feature parity with this great p
2.
by feike 2y ago
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/13 or so!
3.
by feike 2y ago
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 require more work and thought upfront to ensure the binar
4.
by feike 2y ago
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 internally, I have 98% reduction in size of the data). One of the
5.
by feike 3y ago
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 older v
6.
by feike 3y ago
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!
7.
by feike 3y ago
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 power by incorporating the following four additional basic c
8.
by feike 3y ago
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 plrust user functions. https:/&#x2
9.
by feike 4y ago
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 dropping the databases: 08:25:37.114 UTC [1456] LOG:
10.
by feike 4y ago
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 test123 TEMPLATE test_template;` - we tune the Po
11.
by feike 4y ago
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."
12.
by feike 4y ago
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, although that feels a bit awkward. WITH a AS ( i
13.
by feike 4y ago
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: https://use-the-index-luke.com/sql/par
14.
by feike 5y ago
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-3)/6)::smallint
15.
by feike 5y ago
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/feike/adventofcode/-/tre
16.
by feike 6y ago
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 primary when no synchronous standby candidates are available
17.
by feike 6y ago
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/flat/db7b729d-0226-d16...
18.
by feike 6y ago
> 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 not have the lock I will demote. This results in that th
19.
by feike 6y ago
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 this correctly: https://patroni.readthedocs.io/
20.
by feike 7y ago
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
21.
by feike 7y ago
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');
22.
Benchmarking: Do it with transparency or don't do it at all(ongres.com)
4 points by feike 7y ago|0 comments
23.
by feike 7y ago
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 benchmarks and teams running the benchmarks. MongoDB could cr