Kurt Roeckx <Q@ping.be> writes:
> I have a database where I deleted all records from all tables. I
> run a vacuum full and am left with about 1 GB of data.
Indexes maybe? If you don't identify *where* the space is, we can't
say much.
> 2003-04-12 21:30:55 LOG: redo starts at 1/1C128B54
> 2003-04-12 21:32:23 LOG: ReadRecord: unexpected pageaddr
> 1/15AE2000 in log file 1, segment 36, offset 11411456
> 2003-04-12 21:32:23 LOG: redo done at 1/24AE0B60
I believe this is harmless; it's just a possible side-effect from
recycling WAL files. You'd see it when the old WAL happens to end
exactly on a page boundary.
regards, tom lane