News for hackers. Stuff that matters.

A comment on Waiting for PostgreSQL 14 – SEARCH and CYCLE clauses.

Re:Waiting for PostgreSQL 14 – SEARCH and CYCLE clauses by wdb on Thursday February 04, 2021 @01:25PM (#26028256)
Sounds interesting. Recently, I have been looking for a quick approach to make a clone of a production database for use in staging.

The idea to avoid failing migrations by applying against a thin clone of production, as somehow migrations fail in production but work fine in staging. Anyone aware of a quick way to make a clone?

Currently copying a 0.5TB db takes 3 hours while I am dreaming of like minutes.

[ Parent | on HN ]
Re:Waiting for PostgreSQL 14 – SEARCH and CYCLE clauses by aeontech on Thursday February 04, 2021 @04:23PM (#26029966)
Look at pgsync or pgloader

https://news.ycombinator.com/item?id=22676112

There is also interesting work around using filesystem volume snapshots or clones for database cloning, but that requires infrastructural changes… I think there was a startup around that but I can’t find the name :)

https://www.sedlakovi.org/blog/2019/03/fast-postgres-snapsho...

[ Parent | on HN ]
Re:Waiting for PostgreSQL 14 – SEARCH and CYCLE clauses by wdb on Friday February 05, 2021 @02:49AM (#26034064)
Thank you! Your posts let me know to this product: https://postgres.ai/docs/

Looks interesting too

[ Parent | on HN ]