[firebird-support] Re: gstat output about blobs - blob pages 0

2016-07-09 Thread Dmitry Yemanov dim...@users.sourceforge.net [firebird-support]
09.07.2016 19:58, 'livius' wrote: > Now i understand. Short blobs are on data pages, long are on different > pages. > But: > Level 0 are on data pages > , Level 1 on different > , level 2 are ??? https://www.ibphoenix.com/resources/documents/general/doc_54, chapter "Blob Internal Storage" Dmit

Re: [firebird-support] gstat output about blobs - blob pages 0

2016-07-09 Thread 'livius' liviusliv...@poczta.onet.pl [firebird-support]
08.07.2016 15:41, liviuslivius liviusliv...@poczta.onet.pl [firebird-support] wrote: > Blobs: 1976786, total length: 37039763, blob pages: 0 > Level 0: 1976786, >> All BLOBs are level 0, they are kept on data pages with other record >> data. No separate >>BLOB pages. >>-- >> WBR,

Re: [firebird-support] gstat output about blobs - blob pages 0

2016-07-09 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
08.07.2016 15:41, liviuslivius liviusliv...@poczta.onet.pl [firebird-support] wrote: > Blobs: 1976786, total length: 37039763, blob pages: 0 > Level 0: 1976786, All BLOBs are level 0, they are kept on data pages with other record data. No separate BLOB pages. -- WBR, SD.

[firebird-support] gstat output about blobs - blob pages 0

2016-07-09 Thread liviuslivius liviusliv...@poczta.onet.pl [firebird-support]
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