News for hackers. Stuff that matters.
Re:Pg_branch: Pre-alpha Postgres extension brings Neon-like ... by conceptme on Monday October 02, 2023 @01:11PM (#37741207)
So how do you test your migration? Will work fine with 10 records but perhaps not with 10 million.
Re:Pg_branch: Pre-alpha Postgres extension brings Neon-like ... by ComputerGuru on Monday October 02, 2023 @06:06PM (#37745105)
I don’t consider that “a regular test” but something db-specific that would have a custom workflow.
Re:Pg_branch: Pre-alpha Postgres extension brings Neon-like ... by workingjubilee on Monday October 09, 2023 @08:48PM (#37827341)
Eliminating "custom workflows" seems like rather the point of such an extension.
Re:Pg_branch: Pre-alpha Postgres extension brings Neon-like ... by rokkitmensch on Tuesday October 03, 2023 @03:39PM (#37756543)
Run it in a transaction, and if it fails, abort the transaction. nbd, did this for years in prod. Discovered some interesting assumptions about sequential IDs in the DB tests while running it against prod under peak load, too!