[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