[GENERAL] does database shut down cleanly when WAL device fails?

yet written out to the main database tables. Essentially, the documentation does not make clear what recovery can take place - under what guarantees - should the WAL be destroyed in mid-operation. Please advise as to which understanding is the correct one. -- Brandon Craig Rhodes [EMAIL

[GENERAL] AREs in substring(from)

substring('Bar, Foo' FROM '***:\\w') -> NULL whereas I expect these to produce 'B' as well. What am I missing? -- Brandon Craig Rhodes http://www.rhodesmill.org/brandon Georgia Tech[EMAIL PR

Re: [GENERAL] PostgreSQL on XFS experiences?

s no combination of operations which any application, buggy or not, that can cause a properly written XFS driver on error-free hardware to become corrupted. -- Brandon Craig Rhodes http://www.rhodesmill.org/brandon Georgia Tech