the parent table size is not reduced when I type '\d+' after migration #205

Zhu-Ying · 2019-09-09T10:01:44Z

Problem description

the parent table size is not reduced when I type '\d+' after I run 'select partition_table_concurrently('parent_table',10000,1.0);' .
I got 207G before the migration but I still got 207G after migration when I type '\d+'.
It takes 10 minutes and return 0 records when I run the command with ‘select id from parent_table limit 10’ .

Is this the correct result? should I ‘TRUNCATE parent_table’?

Environment

extname | extowner | extnamespace | extrelocatable | extversion | extconfig | extcondition
------------+----------+--------------+----------------+------------+-------------------+--------------
plpgsql | 10 | 11 | f | 1.0 | |
pg_pathman | 1030850 | 2200 | f | 1.5 | {1031004,1031015} | {"",""}

PostgreSQL 11.4 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 4.8.5 20150623 (EulerOS 4.8.5-4), 64-bit

arssher · 2019-12-03T13:10:10Z

I got 207G before the migration but I still got 207G after migration when I type '\d+'.

That's quite normal until you vacuum the parent table (of course you can do that in progress, while partitioning bgw is still running).

It takes 10 minutes and return 0 records when I run the command with ‘select id from parent_table limit 10’

This is definitely not normal; table should always be accessible with all its rows. Examining server logs might help.

should I ‘TRUNCATE parent_table’?

No, worker deletes moved data itself.

Zhu-Ying changed the title ~~e parent table size is not reduced when I type '\d+' after migration~~ the parent table size is not reduced when I type '\d+' after migration Sep 9, 2019

postgrespro / pg_pathman

the parent table size is not reduced when I type '\d+' after migration #205

the parent table size is not reduced when I type '\d+' after migration #205

Zhu-Ying commented Sep 9, 2019 •

edited

arssher commented Dec 3, 2019 •

edited

postgrespro / pg_pathman

Join GitHub today

the parent table size is not reduced when I type '\d+' after migration #205

the parent table size is not reduced when I type '\d+' after migration #205

Comments

Zhu-Ying commented Sep 9, 2019 • edited

Problem description

Environment

arssher commented Dec 3, 2019 • edited

Zhu-Ying commented Sep 9, 2019 •

edited

arssher commented Dec 3, 2019 •

edited