Skip site navigation (1) Skip section navigation (2)

Excess disk usage

From: John Summerfield <summer(at)os2(dot)ami(dot)com(dot)au>
To: pgsql-bugs(at)postgresql(dot)org
Subject: Excess disk usage
Date: 2001-08-28 01:35:51
Message-ID: 200108280135.f7S1ZpN03691@possum.os2.ami.com.au (view raw or flat)
Thread:
Lists: pgsql-bugs
I attempted to load data amounting to 21 mbytes into a table which has 
a unique key both otherwise doesn't have indexes.

The WALs consumed 2.9 Gigabytes of disk (and doubtless would have taken 
more if there was more to be had).


Considering that the entire data would fit into RAM (I have 128 Mbytes) 
I think this a little excessive.

In the interests of having space for other programs, I removed all the 
logs (recognising that I might have to start again).

Now I find that postmaster won't start.

2001-08-28 06:56:48 [5093]   DEBUG:  redo starts at (1, 259081116)
2001-08-28 06:56:54 [5093]   DEBUG:  open(logfile 1 seg 16) failed: No 
such file or directory
2001-08-28 06:56:54 [5093]   DEBUG:  redo done at (1, 268428788)
2001-08-28 06:57:01 [5093]   FATAL 2:  ZeroFill(/var/lib/pgsql/data/pg_x
log/xlogtemp.5093) failed: No such file or directory
/usr/bin/postmaster: Startup proc 5093 exited with status 512 - abort
2001-08-28 09:16:19 [18473]  DEBUG:  database system was shut down at 
2001-08-28 06:57:00 WST
2001-08-28 09:16:19 [18473]  DEBUG:  open(logfile 1 seg 15) failed: No 
such file or directory
2001-08-28 09:16:19 [18473]  DEBUG:  Invalid primary checkPoint record
2001-08-28 09:16:19 [18473]  DEBUG:  open(logfile 1 seg 15) failed: No 
such file or directory
2001-08-28 09:16:19 [18473]  DEBUG:  Invalid secondary checkPoint record
2001-08-28 09:16:19 [18473]  FATAL 2:  Unable to locate a valid 
CheckPoint record
/usr/bin/postmaster: Startup proc 18473 exited with status 512 - abort
[root(at)dugite log]#

The actual messages are no surprise.


I appreciate that I've not provided a lot of information about what I'm 
trying to do. However, I don't think that ANYTHING I do should case PG 
to use so much disk for so little data.


-- 
Cheers
John Summerfield

Microsoft's most solid OS: http://www.geocities.com/rcwoolley/

Note: mail delivered to me is deemed to be intended for me, for my 
disposition.




Responses

pgsql-bugs by date

Next:From: Ron LooiDate: 2001-08-28 07:38:37
Subject: Error on postgresql driver (or pg_hba)
Previous:From: Barry LindDate: 2001-08-27 18:23:08
Subject: Re: Re: [BUGS] Bug #428: Another security issue with the JDBC driver.

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group