2 ms·
A while back, I wrote a blog post that experimented with doing transactional DDL in postgres, and investigating the state of `pg_locks` to check if statements w
by rkaveland 2y ago
A while back, I wrote a blog post that experimented with doing transactional DDL in postgres, and investigating the state of `pg_locks` to check if statements were likely to interfere with queries. I've expanded on this idea and made a tool, that I named `eugene` for the title of the first blog post.
Check out the examples in https://github.com/kaaveland/eugene/tree/main https://github.com/kaaveland/eugene/tree/main or read the blog post -- I would love to have more ideas for where to take this, both concrete migration hints that `eugene` could show people, but also functionality and ways to integrate it into CI.