Changelog
- `geordi dump`: Allow to forward the compression option to the underlying `dumple` command, e.g. `geordi dump --compress=zstd:3` (for PostgreSQL) or `geordi dump --compress` (for MySQL).
- `dumple`: Allow to specify a compression algorithm for PostgreSQL, e.g. `dumple --compress=zstd:3`. The already supported compression for MySQL `dumple --compress` is kept untouched.
In PostgreSQL you will notice a speedup of ~50%.
Example
Performance improvements during a deploy (e.g. lib/capistrano/tasks/db.rake
)
namespace :db do
desc 'Do a dump of the DB on the remote machine using dumple'
task :dump do
on primary :db do
within current_path do
execute :dumple, '--fail-gently', '--compress=zstd:3', fetch(:rails_env, 'production')
end
end
end
end
or when loading a dump geordi dump -l production --compress=zstd:3
.
Posted by Emanuel to makandra dev (2025-09-22 13:43)