Hi, i see in gstat output that blob pages are 0. For every record in this table blob is not null and contain data. I supposed that blobs are on different pages then "table Data pages" and only id is stored within a record. This should report then value >0? What does it mean then "blob pages: 0"? ZLEC_FAKT_COMPARE (338) Primary pointer page: 734, Index root page: 735 Total formats: 1, used formats: 1 Average record length: 72.37, total records: 2013151 Average version length: 0.00, total versions: 0, max versions: 0 Average fragment length: 0.00, total fragments: 0, max fragments: 0 Average unpacked length: 82.00, compression ratio: 1.13 Pointer pages: 7, data page slots: 20448 Data pages: 20448, average fill: 85% Primary pages: 13998, secondary pages: 6450, swept pages: 13998 Empty pages: 0, full pages: 20446 Blobs: 1976786, total length: 37039763, blob pages: 0 Level 0: 1976786, Level 1: 0, Level 2: 0 Fill distribution: 0 - 19% = 1 20 - 39% = 1 40 - 59% = 0 60 - 79% = 13997 80 - 99% = 6449 regards, Karol Bieniaszewski
[firebird-support] gstat output about blobs - blob pages 0
liviuslivius [email protected] [firebird-support] Sat, 09 Jul 2016 05:38:09 -0700
- [firebird-s... liviuslivius [email protected] [firebird-support]
- Re: [f... Dimitry Sibiryakov [email protected] [firebird-support]
- Re... 'livius' [email protected] [firebird-support]
- ... Dmitry Yemanov [email protected] [firebird-support]
- ... [email protected] [firebird-support]
- ... Helen Borrie [email protected] [firebird-support]
