[Reorg-general] unexpected toast relations
Sok Ann Yap
sokann at gmail.com
Tue Aug 18 08:19:40 UTC 2009
Hi there,
I am using pg_reorg-1.0.6 with postgresql-8.3.7, and encountered the
following problem with one of my table when running pg_reorg in
no-order mode:
---- swap ----
ERROR: query failed: ERROR: reorg_swap : unexpected toast relations
(T1=47386, I1=47388, T2=0, I2=0
query was: SELECT reorg.reorg_swap($1)
It was just a simple table with 1 integer primary key, 4 varchars, and
4 timestamps. It used to have a text column but that was dropped about
2 months ago. Can you see what could be the problem? Thanks.
Regards,
Yap
P.S. pg_reorg successfully "VACUUM FULL ANALYSE" my other tables and
reduced the database size by 15%. Nice :)
More information about the Reorg-general
mailing list