| Subject | RE: [firebird-support] Re: How to change database size |
|---|---|
| Author | Coral Johnson |
| Post date | 2006-02-03T07:17:18Z |
Thank you all, that dropped it down to 2mb. We're fairly new to using
Firebird and there's a bit of a learning curve.
Regards Coral
-----Original Message-----
From: firebird-support@yahoogroups.com
[mailto:firebird-support@yahoogroups.com]On Behalf Of Adam
Sent: Friday, 3 February 2006 10:08 AM
To: firebird-support@yahoogroups.com
Subject: [firebird-support] Re: How to change database size
Coral,
When Firebird needs more space it requests it from the OS. When you
delete the records, they are still there until no transaction is
interested in them and the garbage collection is run. The garbage
collection process flags the pages as free to be used again, but does
not hand the space back to the OS. This would be a slow and complex
operation which would end up fragmenting your file system like crazy!
Instead, Firebird will reuse that space again when it next needs it.
A Backup Restore cycle will obviously remove this entirely, but it
will grow again once you store that much data again.
On a side note, please do not use the reply button when posting a new
topic. Even though you changed the subject, it does mess up some
newsreaders, and some people may miss your message.
If you are using the web interface, then click post instead of reply.
If you are using an email client, then create a new message instead
of hitting reply.
Adam
--- In firebird-support@yahoogroups.com, "Coral Johnson"
<coral.johnson@...> wrote:
Visit http://firebird.sourceforge.net and click the Resources item
on the main (top) menu. Try Knowledgebase and FAQ links !
Also search the knowledgebases at http://www.ibphoenix.com
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
Yahoo! Groups Links
Firebird and there's a bit of a learning curve.
Regards Coral
-----Original Message-----
From: firebird-support@yahoogroups.com
[mailto:firebird-support@yahoogroups.com]On Behalf Of Adam
Sent: Friday, 3 February 2006 10:08 AM
To: firebird-support@yahoogroups.com
Subject: [firebird-support] Re: How to change database size
Coral,
When Firebird needs more space it requests it from the OS. When you
delete the records, they are still there until no transaction is
interested in them and the garbage collection is run. The garbage
collection process flags the pages as free to be used again, but does
not hand the space back to the OS. This would be a slow and complex
operation which would end up fragmenting your file system like crazy!
Instead, Firebird will reuse that space again when it next needs it.
A Backup Restore cycle will obviously remove this entirely, but it
will grow again once you store that much data again.
On a side note, please do not use the reply button when posting a new
topic. Even though you changed the subject, it does mess up some
newsreaders, and some people may miss your message.
If you are using the web interface, then click post instead of reply.
If you are using an email client, then create a new message instead
of hitting reply.
Adam
--- In firebird-support@yahoogroups.com, "Coral Johnson"
<coral.johnson@...> wrote:
>has been
> We're developing a new database using Firebird. The database size
> sitting at 8 mb for over a month. One day last week it increasedto 44 mb.
> We have been doing a lot of changes, both to the structure and tothe data,
> over the whole period, so I don't know why it suddenly increased sodecrease the
> dramatically. We have now deleted all the data and want to
> database size again. How can we do that?++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Regards Coral
Visit http://firebird.sourceforge.net and click the Resources item
on the main (top) menu. Try Knowledgebase and FAQ links !
Also search the knowledgebases at http://www.ibphoenix.com
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
Yahoo! Groups Links