Postgres Pro
Downloads
Home   >   mailing lists

Re: Recovery inconsistencies, standby much larger than primary - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Recovery inconsistencies, standby much larger than primary
Date
Msg-id 14470.1391182396@sss.pgh.pa.us
Whole thread Raw
In response to Re: Recovery inconsistencies, standby much larger than primary  (Andres Freund <andres@2ndquadrant.com>)
Responses Re: Recovery inconsistencies, standby much larger than primary  (Andres Freund <andres@2ndquadrant.com>)
Re: Recovery inconsistencies, standby much larger than primary  (Andres Freund <andres@2ndquadrant.com>)
List pgsql-hackers
Tree view 
Andres Freund <andres@2ndquadrant.com> writes:
> It's interesting that the smgr gets this wrong then (as also evidenced
> by the fact that relation_size does as well). Could you please do a ls
> -l path/to/relfilenode*?

IIRC, smgrnblocks will stop as soon as it finds a segment that is not
1GB in size.  Could you check the lengths of all segments for that
relation?
        regards, tom lane

pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: inherit support for foreign tables
Next
From: Andres Freund
Date:
Subject: Re: Recovery inconsistencies, standby much larger than primary