From: | David Boreham <david_list(at)boreham(dot)org> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | zero_damaged_pages doesn't work |
Date: | 2010-09-27 21:07:24 |
Message-ID: | 4CA1078C.7060901@boreham.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Is the zero_damaged_pages feature expected to work in 8.3.11 ?
I have a fair bit of evidence that it doesn't (you get nice messages
in saying that the page is being zeroed, but the on-disk data does not
change).
I also see quite a few folk reporting similar findings in various form
and mailing list posts over the past few years.
I can use dd to zero the on-disk data, but it'd be nice to know
definitively if this feature is expected to work, and if so under
what conditions it might not.
fwiw I am enabling zero_damaged_pages using a set command
in a client session, not in the server's config file. The symptoms
I observe are that a query that previously errored out due to
a bad page header error will succeed when zero_damaged_pages
is enabled, the log says that the page is being zeroed.
However the same query run subsequently without zero_damaged_pages
will again fail, and pg_filedump shows that the on-disk data
hasn't changed.
Thanks.
From | Date | Subject | |
---|---|---|---|
Next Message | Larry Leszczynski | 2010-09-27 22:35:58 | PostgreSQL 9 Mac OS X one-click install - PL/perl broken |
Previous Message | Darren Duncan | 2010-09-27 19:04:40 | Re: Preserving order through an inner join |