Hi,
Is there a way to translate information in pg_xlog files to a more
readable format?
Basically we have someone accidentally emptied a text column containing
quite a large amount of text, and unfortunately have no backups. I know
the pg_xlog is for WAL, and probably is not the proper way to re
Okay, so you have a lot of wide (toasted) fields in whatever table that
toast table belongs to --- if you're not sure, try
select relname from pg_class where
reltoastrelid = (select oid from pg_class where relfilenode = 25677563);
VACUUM VERBOSE on that table would give some useful info.
regard
Is that file still in used (because I can't find it in the pg_class
table)?
Yes. Don't delete it manually.
Thanks for that advice :) I wasn't really going to delete it, just
tempted to.
following Tom's advice, this query:
select relname from pg_class where relfilenode = 25677563;
retu
Hi,
I have been having this problem where the database size suddenly grows
from the normal size of about 300Mb to 12Gb in one night.
When I look up the table size, the biggest one is only 41Mb and the
total of all table size is only 223Mb.
But in the filesystem data directory the total size is 12
