Can we start fleshing subtasks which need to be started to progress this
please? The discussion is going really well!
On 3 Mar 2016 12:20 pm, "Dmitry Yemanov" <firebi...@yandex.ru> wrote:
> 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
>
------------------------------------------------------------------------------
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