this post was submitted on 23 Jun 2023

3 points (100.0% liked)

PostgreSQL

643 readers

1 users here now

The world's most advanced open source relational database

Project

About (history)
Docs
Donate to PostgreSQL
Wiki
Planet PostgreSQL
IRC
Mailing lists:
- pgsql-announce
- pgsql-hackers (developers)
- pgsql-general
- pgsql-jobs
User Groups

Events

SEAPUG Summer BBQ, 6 July in Seattle
SFBA PostgreSQL Meetup, 12 July
Chicago PostgreSQL Meetup, 19 July
PGDay UK 2023, 12 September in London
PGConf 2023, 3-5 October in New York City
PGDay Israel 2023, 19 October
PGConf.EU 2023, 12-15 December in Prague

Podcasts

postgres.fm (feed)

Related Fediverse communities

c/SQL on programming.dev
#sql on Mastodon
#postgresql on Mastodon

founded 1 year ago

MODERATORS

3

GitHub - shayonj/pg-osc: Easy CLI tool for making zero downtime schema changes and backfills in PostgreSQL (github.com)

submitted 1 year ago by jnovinger to c/postgresql

2 comments fedilink hide all child comments

⚠ Proceed with caution when using this on production like workloads. Best to try on similar setup or staging like environment first. Read on below for some examples and caveats.

top 2 comments

sorted by: hot top controversial new old

[–] msage 1 points 1 year ago (1 children)

Anyone tried this?

I've been using Percona Online Schema Change in MySQL, and that works great... until it renames a big table that needs to be fully in memory, and every query waits for the disk reads.

But I'm not sure anyone can deal with that.

[–] jnovinger 1 points 1 year ago

I have not yet, but hoping to be able to test it out on some DEV databases soon.