Subject gstat output about blobs - blob pages 0
Author liviuslivius
Post date 2016-07-09T12:37:05Z
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