Re: Transaction problem? - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Transaction problem?
Date
Msg-id 10910.1050449012@sss.pgh.pa.us
Whole thread Raw
In response to Transaction problem?  (Kurt Roeckx <Q@ping.be>)
Responses Re: Transaction problem?  (Kurt Roeckx <Q@ping.be>)
List pgsql-hackers
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



pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: Foreign Database Connectivity
Next
From: Tom Lane
Date:
Subject: Re: Are we losing momentum?