search

reorg / pg_repack

Reorganize tables in PostgreSQL databases with minimal locks
BSD 3-Clause "New" or "Revised" License
1.85k stars 170 forks source link

Include --no-presistence-check for repacking unlogged tables #164

Open LinAnt opened 6 years ago

LinAnt commented 6 years ago

Hi, I have been using pg_repack for quite some time and when recently upgrading to PostgreSQL 10 and a newer version of pg_repack I noticed the support for unlogged tables is gone.

I tried recompiling pg_repack version 1.4.2 after reverting this change: #72 but I still hangs: sudo -u postgres ./pg_repack test_database --echo --no-order --table=unlogged_table LOG: (query) select repack.version(), repack.version_sql() LOG: (query) SET statement_timeout = 0 LOG: (query) SET search_path = pg_catalog, pg_temp, public LOG: (query) SET client_min_messages = warning LOG: (query) SELECT t.*, coalesce(v.tablespace, t.tablespace_orig) as tablespace_dest FROM repack.tables t, (VALUES (quote_ident($1::text))) as v (tablespace) WHERE (relid = $2::regclass) ORDER BY t.relname, t.schemaname LOG: (param:0) = (null) LOG: (param:1) = unlogged_table

Any suggestions on what else I might have missed? It would be great if one could force repacking of unlogged tables with a flag like --no-presistence-check or something similiar.

Regards, Anton Lindholm

donflopez commented 5 years ago

I'm having the same issue, news on this? Thanks!

LinAnt commented 5 years ago

We stayed on an older PG version and used the old PG repack for a while, then we deprecated that part of the stack :/