Re: Removing oids with pg_repack

Στις 27/11/23 16:51, ο/η CG έγραψε: On Wednesday, November 22, 2023 at 12:38:54 PM EST, Achilleas Mantzios wrote: Στις 22/11/23 15:14, ο/η CG έγραψε: On Wednesday, November 22, 2023 at 01:20:18 AM EST, Achilleas Mantzios wrote: Στις 21/11/23

Re: Removing oids with pg_repack

On Wednesday, November 22, 2023 at 12:38:54 PM EST, Achilleas Mantzios wrote: Στις 22/11/23 15:14, ο/η CG έγραψε: On Wednesday, November 22, 2023 at 01:20:18 AM EST, Achilleas Mantzios wrote: Στις 21/11/23 20:41, ο/η CG έγραψε: I have a very large

Re: Removing oids with pg_repack

Στις 22/11/23 15:14, ο/η CG έγραψε: On Wednesday, November 22, 2023 at 01:20:18 AM EST, Achilleas Mantzios wrote: Στις 21/11/23 20:41, ο/η CG έγραψε: I have a very large PostgreSQL 9.5 database that still has very large tables with oids. I'm trying to get rid of the oids with as little d

Re: Removing oids with pg_repack

CG writes: > I have the fallback position for the Percona ETL strategy. But I feel like > I'm REALLY close with pg_repack and I just don't understand enough about the > system internals to nudge it to correctness and need some expert assistance > to tap it in the hole. The only "system metadat

Re: Removing oids with pg_repack

On Tue, Nov 21, 2023 at 1:43 PM CG wrote: > I have a very large PostgreSQL 9.5 database that still has very large > tables with oids. I'm trying to get rid of the oids with as little downtime > as possible so I can prep the database for upgrade past PostgreSQL 11. I > had a wild idea to mod pg_re

Re: Removing oids with pg_repack

On Wednesday, November 22, 2023 at 01:20:18 AM EST, Achilleas Mantzios wrote: Στις 21/11/23 20:41, ο/η CG έγραψε: I have a very large PostgreSQL 9.5 database that still has very large tables with oids. I'm trying to get rid of the oids with as little downtime as possible so I

Re: Removing oids with pg_repack

Στις 21/11/23 20:41, ο/η CG έγραψε: I have a very large PostgreSQL 9.5 database that still has very large tables with oids. I'm trying to get rid of the oids with as little downtime as possible so I can prep the database for upgrade past PostgreSQL 11. I had a wild idea to mod pg_repack to writ

Removing oids with pg_repack

I have a very large PostgreSQL 9.5 database that still has very large tables with oids. I'm trying to get rid of the oids with as little downtime as possible so I can prep the database for upgrade past PostgreSQL 11. I had a wild idea to mod pg_repack to write a new table without oids. I think i