Re: [HACKERS] Hi

From: Mattias Kregert <matti(at)algonet(dot)se>
To: "Thomas G(dot) Lockhart" <lockhart(at)alumni(dot)caltech(dot)edu>
Cc: pgsql-hackers(at)postgreSQL(dot)org
Subject: Re: [HACKERS] Hi
Date: 1998-02-05 14:56:51
Message-ID: 34D9D332.10C4BB8E@algonet.se
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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 */

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Peter T Mount 1998-02-05 15:15:38 Re: [HACKERS] connection troubles
Previous Message Michael Meskes 1998-02-05 14:50:54 Preprocessor