03.03.2016 00:51, Vlad Khorsun wrote: > > Blobs could be moved into separate tablespace. It could make backup of > "data" tablespace faster and smaller. We can even think about "offline" > tablespace.
Really good idea. Maybe more important for an average FB user than the other usage cases. > There is implicit assumption that all table's pointer, data, index and blob > pages allocated at the same tablespace. Supposedly, it should be possible to fix/improve. > pag.h contains following: > > // page spaces below TEMP_PAGE_SPACE is regular database pages > // TEMP_PAGE_SPACE and page spaces above TEMP_PAGE_SPACE is temporary pages > const USHORT DB_PAGE_SPACE = 1; > const USHORT TEMP_PAGE_SPACE = 256; So we have room for 255 pagespaces now. It should be OK for tablespaces, although may be not enough for partitions... > Shadows. It is not clear (for me at least) should a shadow be defined for > a whole database or per-tablespace level ? At the first glance, I think the whole database. But it should be carefully thought out. > Also, PIP and Header page. Should every tablespace contains its own PIP ? > Currently, every page space have own PIP, but only DP_PAGE_SPACE contains > own Header page.. Again at the first glance: PIPs are per tablespace. As for headers, I'm not that sure. It looks logical if we allow to override some database settings at the tablespace level: e.g. no-reserve, FW. But the same effect could be achieved by storing the custom setting in RDB$TABLESPACES (which is to be accessed anyway before any tablespace is being opened). Dmitry ------------------------------------------------------------------------------ Site24x7 APM Insight: Get Deep Visibility into Application Performance APM + Mobile APM + RUM: Monitor 3 App instances at just $35/Month Monitor end-to-end web transactions and take corrective actions now Troubleshoot faster and improve end-user experience. Signup Now! http://pubads.g.doubleclick.net/gampad/clk?id=272487151&iu=/4140 Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel