はてなブックマーク

Sounds a little self-serving, no? Sure – bugs happen. No, they shouldn’t exist for 14+ years before being fixed. MySQL (through various owners over time) is still, more-or-less, and open-source project. Obviously, that bug wasn’t considered “bad” enough to worry about (IOW – there were higher-priority issues for well over a decade that kept pushing that one down the list). But it *sounds* like you

> pg_basebackup first issues a checkpoint to ensure it gets the latest data for the backup, which by default is a paced checkpoint to avoid hitting the disks too hard. As a result it can take a few minutes, typically about 4 minutes with default settings to start up. During that time the pg_basebackup process is quiet while it waits for the checkpoint on the master to complete. Seems like this cou

I’m pleased to say that Postgres-BDR is on its way to PostgreSQL 9.6, and even better, it works without a patched PostgreSQL. BDR has always been an extension, but on 9.4 it required a heavily patched PostgreSQL, one that isn’t fully on-disk-format compatible with stock community PostgreSQL 9.4. The goal all along has been to allow it to run as an extension on an unmodified PostgreSQL … and now we

2ndQuadrant is now part of EDBBringing together some of the world's top PostgreSQL experts. Sometimes SELECT pg_backend_pid() and gdb‘s attach aren’t enough. You might have a variable in shared memory that’s being changed by some unknown backend at some unknown time. Or a function that’s called from somewhere, but you don’t know where or when. I’ve recently been doing quite a bit of work on code w

pglogical is a logical replication system implemented entirely as a PostgreSQL extension. Fully integrated, it requires no triggers or external programs. This alternative to physical replication is a highly efficient method of replicating data using a publish/subscribe model for selective replication. pglogical forms the foundation for BDR – which runs as an extension on top of it – providing the

2ndQuadrant is now part of EDBBringing together some of the world's top PostgreSQL experts.