Re: [Firebird-devel] File and table sizes in Firebird 4.0

2021-08-15 Thread Mark Rotteveel
On 14-08-2021 21:26, Roman Simakov wrote: I think it's a good idea to keep not only limits but the formulas for their calculations. Already done for the maximum file size and maximum index key size. Mark -- Mark Rotteveel Firebird-Devel mailing list, web interface at

Re: [Firebird-devel] File and table sizes in Firebird 4.0

2021-08-14 Thread Roman Simakov
I think it's a good idea to keep not only limits but the formulas for their calculations. сб, 14 авг. 2021 г. в 10:32, Mark Rotteveel : > > On 14-08-2021 09:12, Dmitry Yemanov wrote: > > 14.08.2021 10:02, Mark Rotteveel пишет: > >> > >>> Now I see you mentioned 32 TB as the database size limit.

Re: [Firebird-devel] File and table sizes in Firebird 4.0

2021-08-14 Thread Mark Rotteveel
On 14-08-2021 09:12, Dmitry Yemanov wrote: 14.08.2021 10:02, Mark Rotteveel пишет: Now I see you mentioned 32 TB as the database size limit. How was it calculated? It should be the same 128 TB, AFAIK. The 32 TB is the old value on the page, when the entire page was for Firebird 2.5. I have

Re: [Firebird-devel] File and table sizes in Firebird 4.0

2021-08-14 Thread Dmitry Yemanov
14.08.2021 10:02, Mark Rotteveel пишет: Now I see you mentioned 32 TB as the database size limit. How was it calculated? It should be the same 128 TB, AFAIK. The 32 TB is the old value on the page, when the entire page was for Firebird 2.5. I have no idea who wrote the previous version of

Re: [Firebird-devel] File and table sizes in Firebird 4.0

2021-08-14 Thread Mark Rotteveel
On 14-08-2021 08:49, Dmitry Yemanov wrote: 13.08.2021 10:04, Mark Rotteveel wrote: I'd still like an answer to the following questions (assume page size 32KB for all): - What is the maximum file size of a Firebird 4 database Theoretically unlimited (depends on OS and filesystem).

Re: [Firebird-devel] File and table sizes in Firebird 4.0

2021-08-14 Thread Dmitry Yemanov
13.08.2021 10:04, Mark Rotteveel wrote: I'd still like an answer to the following questions (assume page size 32KB for all): - What is the maximum file size of a Firebird 4 database Theoretically unlimited (depends on OS and filesystem). Practically, it cannot be bigger than 128 TB (2^32

Re: [Firebird-devel] File and table sizes in Firebird 4.0

2021-08-13 Thread Mark Rotteveel
On 06-08-2021 14:27, Mark Rotteveel wrote: I'm looking at updating https://firebirdsql.org/en/firebird-technical-specifications/, but I'm wondering if anything changed for some of the sizes listed on that page. Specifically, does the introduction of page size 32KB change anything for the

Re: [Firebird-devel] File and table sizes in Firebird 4.0

2021-08-07 Thread Mark Rotteveel
On 06-08-2021 14:37, Jiří Činčura wrote: Definitely BLOB size should be bigger. Index key length too. The listed blob size is even wrong for Firebird 2.5. I created a 128 GB blob on Firebird 2.5 with page size 16KB. I wonder if it intended to say >32GB instead of <32GB. Mark -- Mark

Re: [Firebird-devel] File and table sizes in Firebird 4.0

2021-08-07 Thread Dimitry Sibiryakov
07.08.2021 10:43, Mark Rotteveel wrote: In other words, what you initially said, "It is still limited to uint32 for total size", is not correct. It was about "total size" internal structure member. I don't know if it is used for anything else but info item. -- WBR, SD. Firebird-Devel

Re: [Firebird-devel] File and table sizes in Firebird 4.0

2021-08-07 Thread Mark Rotteveel
On 06-08-2021 18:20, Dimitry Sibiryakov wrote: 06.08.2021 18:11, Mark Rotteveel wrote: That document says <32GB for blob, if it is restricted to unit32, then the limit should be <4GB, right?   Limit is 4GB for corresponding info item. The BLOB itself can be longer if you "just read/write"

Re: [Firebird-devel] File and table sizes in Firebird 4.0

2021-08-06 Thread Dimitry Sibiryakov
06.08.2021 18:11, Mark Rotteveel wrote: That document says <32GB for blob, if it is restricted to unit32, then the limit should be <4GB, right? Limit is 4GB for corresponding info item. The BLOB itself can be longer if you "just read/write" it. -- WBR, SD. Firebird-Devel mailing list,

Re: [Firebird-devel] File and table sizes in Firebird 4.0

2021-08-06 Thread Mark Rotteveel
On 06-08-2021 16:16, Dimitry Sibiryakov wrote: 06.08.2021 14:55, Mark Rotteveel wrote: What would be the new max size of blobs?   Nothing changed about BLOBs. It is still limited to uint32 for total size and seek location. That document says <32GB for blob, if it is restricted to unit32,

Re: [Firebird-devel] File and table sizes in Firebird 4.0

2021-08-06 Thread Dimitry Sibiryakov
06.08.2021 14:55, Mark Rotteveel wrote: What would be the new max size of blobs? Nothing changed about BLOBs. It is still limited to uint32 for total size and seek location. -- WBR, SD. Firebird-Devel mailing list, web interface at

Re: [Firebird-devel] File and table sizes in Firebird 4.0

2021-08-06 Thread Mark Rotteveel
On 06-08-2021 14:37, Jiří Činčura wrote: Definitely BLOB size should be bigger. Index key length too. Good point, index key length I was aware of. What would be the new max size of blobs? Mark -- Mark Rotteveel Firebird-Devel mailing list, web interface at

Re: [Firebird-devel] File and table sizes in Firebird 4.0

2021-08-06 Thread Jiří Činčura
Definitely BLOB size should be bigger. Index key length too. -- Mgr. Jiří Činčura https://www.tabsoverspaces.com/ Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel

[Firebird-devel] File and table sizes in Firebird 4.0

2021-08-06 Thread Mark Rotteveel
I'm looking at updating https://firebirdsql.org/en/firebird-technical-specifications/, but I'm wondering if anything changed for some of the sizes listed on that page. Specifically, does the introduction of page size 32KB change anything for the maximum file size and maximum size of one table?