| From: | Francisco Reyes <lists(at)natserv(dot)com> |
|---|---|
| To: | pgsql General List <pgsql-general(at)postgresql(dot)org> |
| Subject: | Handling of out of space condition |
| Date: | 2003-06-02 19:11:49 |
| Message-ID: | 20030602135232.Q1174@zoraida.natserv.net |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Not sure if this is a known issue or a bug to be reported.
One of my database machines ran out of space.
Tried to truncate a table and got a error that could not expand a
table(don't recall exact message). Found some data to delete and then
tried truncate again. It worked.
Tried "vacuum full" to clean space and got several files with errors:
Cannot read block ### of table <Tablename> I/O error.
Ended up having to drop and reload the tables in question.
As bad as a out of space condition is, shouldn't the database handle it
better? Shouldn't truncate be able to be run even if disk is full?
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Ron Johnson | 2003-06-02 19:16:21 | Re: The best |
| Previous Message | Jim C. Nasby | 2003-06-02 19:09:21 | Re: Solaris 2.8 (sparc) |