Re: [HACKERS] Hi - Mailing list pgsql-hackers

From Mattias Kregert
Subject Re: [HACKERS] Hi
Date
Msg-id 34D9D332.10C4BB8E@algonet.se
Whole thread Raw
In response to Hi  (Michael Meskes <meskes@topsystem.de>)
List pgsql-hackers
Thomas G. Lockhart wrote:
>
>   - recovery of munged databases (I think disk full conditions may cause
> damage)

I have filled up the disk lots of times, but never had any problems
with corrupted data. When inserting, the backend simply says:
"mytable: cannot extend" and the insert fails.

The only problem I've had is with SELECT and ORDER BY, where the
sort files fill up the disk, and the backend either hangs or returns
zero rows. This can of course cause serious problems if an application
does something bad when a select returns zero rows (like re-initializing
the whole database or something... ooooh noooo...).

/* m */

pgsql-hackers by date:

Previous
From: Michael Meskes
Date:
Subject: Preprocessor
Next
From: "Thomas G. Lockhart"
Date:
Subject: Re: [QUESTIONS] impossible insert data into VARCHAR