"Scott Marlowe" <scott.marlowe@xxxxxxxxx> writes: > On Thu, Oct 30, 2008 at 4:01 PM, Gregory Stark <stark@xxxxxxxxxxxxxxxx> wrote: >> I can't really see trusting Postgres on a filesystem that felt free to >> compress portions of it. Would the filesystem still be able to guarantee that >> torn pages won't "tear" across adjacent blocks? What about torn pages that >> included hint bits being set? > I can't see PostgreSQL noticing it. PostgreSQL hands the OS a 512byte > block, the OS compresses it and it's brethren as the go to disk, > uncompresses as they come out, and as long as what you put in is what > you get back it shouldn't really matter. I think Greg's issue is exactly about what guarantees you'll have left after the data that comes back fails to be the data that went in. regards, tom lane -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
