Subject | Re: [firebird-support] TMP space required during restore |
---|---|
Author | Alexey Kovyazin |
Post date | 2012-01-26T17:34:05Z |
Rick,
No.
Download our free tool DBInfo
(http://ib-aid.com/products/firebird_interbase/monitoring/dbinfo) and
open your database there.
Look at Index Pages size. If you have the single table with the single
index in the database, it will be close to the size you need to have in
Temp, otherwise it will be less (during restore indices are being built
one by one).
Detailed breakdown for each index you can figure out by investigating
gstat -r statistics (or look at IBAnalyst to have it visualized):
http://www.ib-aid.com/images/ibanalyst_index_size.png
Regards,
Alexey Kovyazin
IBSurgeon (www.ib-aid.com)
>So to restore an 11GB database we should have 22GB available whereTempDirectories points?
No.
Download our free tool DBInfo
(http://ib-aid.com/products/firebird_interbase/monitoring/dbinfo) and
open your database there.
Look at Index Pages size. If you have the single table with the single
index in the database, it will be close to the size you need to have in
Temp, otherwise it will be less (during restore indices are being built
one by one).
Detailed breakdown for each index you can figure out by investigating
gstat -r statistics (or look at IBAnalyst to have it visualized):
http://www.ib-aid.com/images/ibanalyst_index_size.png
Regards,
Alexey Kovyazin
IBSurgeon (www.ib-aid.com)
>[Non-text portions of this message have been removed]
> Disclaimer: This message (including attachments) is confidential and
> may be privileged. If you have received it by mistake please notify
> the sender by return e-mail and delete this message from your system.
> Any unauthorized use or dissemination of this message in whole or in
> part is strictly prohibited. Please note that e-mails are susceptible
> to change. RxStrategies, Inc. shall not be liable for the improper or
> incomplete transmission of the information contained in this
> communication or for any delay in its receipt or damage to your
> system. RxStrategies, Inc. does not guarantee that the integrity of
> this communication has been maintained nor that this communication is
> free from viruses, interceptions or interference.
>
>