Re: [firebird-support] What makes a database file size so big?
On 29/03/16 11:44, Małgorzata Barchańska go...@fastdata.com.pl [firebird-support] wrote: > I'm very curious - so what makes our database file so big? Sum of clear > metadata > and raw data is about 2,4GB, and what with other 12GB? Is anything we > can do to shrink our big database file (drop useless indexes or > something like that)? You could try running your database through gstat.exe (in your bin-directory of Filebird, if you installed the development tools with it). You can learn a lot about the way the database-pages are filled per table. You can find a manual for it here: http://www.firebirdsql.org/pdfmanual/Firebird-gstat.pdf Grtz, Rik
Re: [firebird-support] What makes a database file size so big?
Hi, download HQbird Standard trial (http://ib-aid.com/en/hqbird/) and analyze your database statistics with Database Analyst and database file DBInfo. Database Analyst will give you an exact information of tables and indices sizes tab Tables -> sort on Size), their fragmentation due to versioning and blobs. DBinfo will give you information about distribution of pages with numbers and percentage of page types. Regards, Alexey Kovyazin IBSurgeon www.ib-aid.com Hi, I use firebird 2.5 classic server on windows operating system. Because our database file is quite big (18GB) and it starts to cause (because of its size) some maintenance inconvenience we decided to try to shrink it. After checking database statistics we deleted "useless" records in tables that took the most space, we updated old useless blob fields with null values. After backup and restore it turned out that new database is only 3GB smaller than original. We checked the statistics and according to results we have 2,3GB raw data in database file. Restore only metadata creates database of 70MB size, restoring without active indexes results with file 500MB smaller than original. I'm very curious - so what makes our database file so big? Sum of clear metadata and raw data is about 2,4GB, and what with other 12GB? Is anything we can do to shrink our big database file (drop useless indexes or something like that)? Thank you in advance for your answer. Best regards, Małgorzata Barchańska -- Pozdrawiam Małgorzata Barchańska Fast Data Sp. z o.o. Aleja Zwycięstwa 96/98, 81-451 Gdynia Tel.: (58) 732 72 01 http://www.fastdata.com.pl/ NIP : 5862214954,REGON : 220595046 KRS : 304310, Kapitał zakładowy 50 000 zł
[firebird-support] What makes a database file size so big?
Hi, I use firebird 2.5 classic server on windows operating system. Because our database file is quite big (18GB) and it starts to cause (because of its size) some maintenance inconvenience we decided to try to shrink it. After checking database statistics we deleted "useless" records in tables that took the most space, we updated old useless blob fields with null values. After backup and restore it turned out that new database is only 3GB smaller than original. We checked the statistics and according to results we have 2,3GB raw data in database file. Restore only metadata creates database of 70MB size, restoring without active indexes results with file 500MB smaller than original. I'm very curious - so what makes our database file so big? Sum of clear metadata and raw data is about 2,4GB, and what with other 12GB? Is anything we can do to shrink our big database file (drop useless indexes or something like that)? Thank you in advance for your answer. Best regards, Małgorzata Barchańska -- Pozdrawiam Małgorzata Barchańska Fast Data Sp. z o.o. Aleja Zwycięstwa 96/98, 81-451 Gdynia Tel.: (58) 732 72 01 http://www.fastdata.com.pl/ NIP : 5862214954,REGON : 220595046 KRS : 304310, Kapitał zakładowy 50 000 zł