Lists: | pgsql-bugs |
---|
From: | ZIV - Beratung <bteamlab(at)uni-muenster(dot)de> |
---|---|
To: | <pgsql-bugs(at)postgresql(dot)org> |
Subject: | TOAST tables bug restoring to PostgreSQL 9.0.4 |
Date: | 2011-07-25 18:04:16 |
Message-ID: | permail-201107251804166981cf3e00000745-bteamlab@message-id.uni-muenster.de |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-bugs |
Hello PostgreSQL-Team,
i have got a problem with PostgreSQL 9.0.4.
I want to migrate.
If I dump (pg_dump 8.3) any 8.3 PostgreSQL-Database and then
restore (pg_restore 9.0.4) to a PostgreSQL 9.0.4 Database,
the relpages information concerning restored TOAST-tables in pg_class is
wrong.
The relpages entries are all 0 (or 1(TOAST-Index-relations))!
First I thought all information is missing, lost while being dumped and
restored
BUT
select pg_table_size(oid) [oid of the real table i.e. containing pictures]
is (by for example factor 10) bigger than
pg_relation_size(oid) in these cases.
(Also
- the pg_total_relation_size ist only about 10% smaller than that of its
migration-origin,
so the size i think is generally o.k, comprising some compression
improvement in the new Version
- the pg_relation_size ist also about 10% smaller than that of its
migration-origin,
so it's not detoasted in any way.
)
relpages entries for PostgreSQL-own-TOAST-Tables of pg_statistics and
pg_rewrite are o.k.
Any help/fix would be appreciated.
Arne
From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
---|---|
To: | ZIV - Beratung <bteamlab(at)uni-muenster(dot)de> |
Cc: | pgsql-bugs(at)postgresql(dot)org |
Subject: | Re: TOAST tables bug restoring to PostgreSQL 9.0.4 |
Date: | 2011-07-25 18:20:10 |
Message-ID: | 12401.1311618010@sss.pgh.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-bugs |
ZIV - Beratung <bteamlab(at)uni-muenster(dot)de> writes:
> If I dump (pg_dump 8.3) any 8.3 PostgreSQL-Database and then
> restore (pg_restore 9.0.4) to a PostgreSQL 9.0.4 Database,
> the relpages information concerning restored TOAST-tables in pg_class is
> wrong.
> The relpages entries are all 0 (or 1(TOAST-Index-relations))!
This isn't a bug, it just indicates no ANALYZE has happened yet.
regards, tom lane