Mailing-List: contact derby-user-help@db.apache.org; run by ezmlm
Precedence: bulk
Reply-To: "Derby Discussion" <derby-user@db.apache.org>
Received-SPF: pass (athena.apache.org: local policy)
Date: Thu, 21 Feb 2008 17:20:40 +0530
From: Narayanan <V.Narayanan@Sun.COM>
Subject: Re: Enormous file size for an empty table
In-reply-to: <200802211143.m1LBhVvk017042@pyramid-03.kattare.com>
Sender: V.Narayanan@Sun.COM
To: Derby Discussion <derby-user@db.apache.org>
Message-id: <47BD6590.6090209@sun.com>
MIME-version: 1.0
Content-type: text/plain; format=flowed; charset=ISO-8859-1
Content-transfer-encoding: 7BIT
References: <200802211143.m1LBhVvk017042@pyramid-03.kattare.com>
User-Agent: Thunderbird 2.0.0.6 (X11/20071022)

Sai Pullabhotla wrote:
>
> Did you have a bunch of data in that table/other tables which has now 
> been deleted?
>
>  
>
> If so, what you are seeing is normal. Derby does not automatically 
> reclaim the disk space when data is deleted off the tables. However, 
> that disk space is reused when you insert any new data. To reclaim the 
> disk space, I believe there is a stored procedure that you can call 
> which can be found in the documentation.
>

http://db.apache.org/derby/docs/dev/ref/rrefaltertablecompress.html
http://db.apache.org/derby/docs/dev/ref/rrefproceduresinplacecompress.html
>
>  
>
> Sai Pullabhotla
>
> President
>
> jMethods, Inc.
>
> Phone: +1 (402) 408-5753
>
> Fax: +1 (402) 408-6861
>
> www.jMethods.com <http://www.jMethods.com>
>
> ------------------------------------------------------------------------
>
> *From:* Diogo Bastos [mailto:bastos.diogo@gmail.com]
> *Sent:* Thursday, February 21, 2008 4:28 AM
> *To:* derby-user@db.apache.org
> *Subject:* Enormous file size for an empty table
>
>  
>
> Good morning,
>
> I've been starting to use Derby only a few weeks ago so I'm still very 
> "green" on a lot of things concerning it.
>
> One of the problems I've been having so far is that I have a table 
> that is taking me something like 1.2Gb of hard drive space - but 
> here's the catch: that table is empty!
>
> Is this normal? Have I probably done something wrong?
>
> I would appreciate if someone could help me out on this.
>
> Thanks in advance,
> Diogo
>