Re: [Firebird-devel] Maximum number of HashSlots

2021-12-06 Thread Roman Simakov
пн, 6 дек. 2021 г. в 23:07, Dimitry Sibiryakov : > > Roman Simakov wrote 06.12.2021 18:50: > > It looks so and we've returned to my original question) > >Actually no. It is still unknown which version of Firebird 3.0 you watched > and which hash was used. Actually, yes. I use the up-to-date

Re: [Firebird-devel] Maximum number of HashSlots

2021-12-06 Thread Dimitry Sibiryakov
Roman Simakov wrote 06.12.2021 18:50: It looks so and we've returned to my original question) Actually no. It is still unknown which version of Firebird 3.0 you watched and which hash was used. -- WBR, SD. Firebird-Devel mailing list, web interface at

Re: [Firebird-devel] Maximum number of HashSlots

2021-12-06 Thread Roman Simakov
пн, 6 дек. 2021 г. в 15:26, Dimitry Sibiryakov : > > Roman Simakov wrote 06.12.2021 13:16: > > Can you point me to the commit? I see no difference between 3 and 5 > > versions of InternalHash::hash implementation. > >It looks like using of CRC32C was backported into some 3.0.X. Original >

Re: [Firebird-devel] Maximum number of HashSlots

2021-12-06 Thread Dimitry Sibiryakov
Roman Simakov wrote 06.12.2021 13:16: Can you point me to the commit? I see no difference between 3 and 5 versions of InternalHash::hash implementation. It looks like using of CRC32C was backported into some 3.0.X. Original commit was

Re: [Firebird-devel] Maximum number of HashSlots

2021-12-06 Thread Roman Simakov
Can you point me to the commit? I see no difference between 3 and 5 versions of InternalHash::hash implementation. пн, 6 дек. 2021 г. в 14:35, Dimitry Sibiryakov : > > Dimitry Sibiryakov wrote 06.12.2021 12:26: > > Hashing function has been changed to one with supposedly "more even" > >

Re: [Firebird-devel] Maximum number of HashSlots

2021-12-06 Thread Dimitry Sibiryakov
Dimitry Sibiryakov wrote 06.12.2021 12:26: Hashing function has been changed to one with supposedly "more even" distribution of values. BTW a side effect of this change is that number of slots doesn't have to be prime anymore. -- WBR, SD. Firebird-Devel mailing list, web interface at

Re: [Firebird-devel] Maximum number of HashSlots

2021-12-06 Thread Dimitry Sibiryakov
Roman Simakov wrote 06.12.2021 12:21: 3.0. Were there any changes in 4 or 5? Yes. Hashing function has been changed to one with supposedly "more even" distribution of values. -- WBR, SD. Firebird-Devel mailing list, web interface at

Re: [Firebird-devel] Maximum number of HashSlots

2021-12-06 Thread Roman Simakov
пн, 6 дек. 2021 г. в 14:08, Dimitry Sibiryakov : > > Roman Simakov wrote 06.12.2021 10:24: > > We can see: > > Hash slots: 65521, Hash lengths (min/avg/max):0/ 13/ 30 > > Under heavy load. > >On which version do you see it? 3.0. Were there any changes in 4 or 5? >As long as the

Re: [Firebird-devel] Maximum number of HashSlots

2021-12-06 Thread Dimitry Sibiryakov
Roman Simakov wrote 06.12.2021 10:24: We can see: Hash slots: 65521, Hash lengths (min/avg/max):0/ 13/ 30 Under heavy load. On which version do you see it? As long as the first number is zero increasing number of slots won't help. -- WBR, SD. Firebird-Devel mailing list, web

Re: [Firebird-devel] Maximum number of HashSlots

2021-12-06 Thread Roman Simakov
пн, 6 дек. 2021 г. в 12:47, Alex Peshkoff via Firebird-devel : > > On 12/6/21 12:24, Roman Simakov wrote: > > Hello! > > > > Isn't it time to increase the maximum number of HashSlots and make it > > ULONG instead of USHORT? We can see: > > Hash slots: 65521, Hash lengths (min/avg/max):0/ 13/

Re: [Firebird-devel] Maximum number of HashSlots

2021-12-06 Thread Alex Peshkoff via Firebird-devel
On 12/6/21 12:24, Roman Simakov wrote: Hello! Isn't it time to increase the maximum number of HashSlots and make it ULONG instead of USHORT? We can see: Hash slots: 65521, Hash lengths (min/avg/max):0/ 13/ 30 Under heavy load. In FB5? Firebird-Devel mailing list, web interface at