Scott Marlowe escribió: > On Thu, Oct 30, 2008 at 7:37 PM, Alvaro Herrera > <alvherre@xxxxxxxxxxxxxxxxx> wrote: > > Scott Marlowe escribió: > > > >> What is the torn page problem? Note I'm no big fan of compressed file > >> systems, but I can't imagine them not working with databases, as I've > >> seen them work quite reliably under exhange server running a db > >> oriented storage subsystem. And I can't imagine them not being > >> invisible to an application, otherwise you'd just be asking for > >> trouble. > > > > Exchange, isn't that the thing that's very prone to corrupted databases? > > I've heard lots of horror stories about that (and also about how you > > have to defragment the database once in a while, so what kind of > > database it really is?) > > Sure, bash Microsoft it's easy. But it doesn't address the point, is > a database safe on top of a compressed file system and if not, why? I'm not bashing Microsoft. I'm just saying that your example application already shows signs that could, perhaps, be explained by the hypothesis put forward by Greg -- that a compressed filesystem is more prone to corruption. -- Alvaro Herrera http://www.CommandPrompt.com/ The PostgreSQL Company - Command Prompt, Inc. -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
