Re: [Firebird-devel] Firebird 4 database creation speed

2020-10-19 Thread Dimitry Sibiryakov
19.10.2020 19:09, Dimitry Sibiryakov wrote: the time between the command has been issued and the error is shown. And if you didn't notice: firebird.conf is default which means that legacy auth is disabled on server side. I though that in this case client and server must negotiate about used

Re: [Firebird-devel] Firebird 4 database creation speed

2020-10-19 Thread Dimitry Sibiryakov
19.10.2020 18:51, Alex Peshkoff via Firebird-devel wrote: Because in default case one gets something like (no users at all): The question was not about error I got (it was the same in both cases) but about the time between the command has been issued and the error is shown. -- WBR, SD.

Re: [Firebird-devel] Firebird 4 database creation speed

2020-10-19 Thread Alex Peshkoff via Firebird-devel
On 10/19/20 5:00 PM, Dimitry Sibiryakov wrote: Hello All.   With current Firebird 4 snapshot with default firebird.conf (legacy auth disabled) and no Srp SYSDBA user, the query create database "localhost:crypt_test" user "SYSDBA" password "masterke"; is much slower than create database "loc

[Firebird-devel] [FB-Tracker] Created: (CORE-6422) Database key holder is not used by default for backup file

2020-10-19 Thread Dimitry Sibiryakov (JIRA)
Database key holder is not used by default for backup file -- Key: CORE-6422 URL: http://tracker.firebirdsql.org/browse/CORE-6422 Project: Firebird Core Issue Type: Bug Compon

[Firebird-devel] Firebird 4 database creation speed

2020-10-19 Thread Dimitry Sibiryakov
Hello All. With current Firebird 4 snapshot with default firebird.conf (legacy auth disabled) and no Srp SYSDBA user, the query create database "localhost:crypt_test" user "SYSDBA" password "masterke"; is much slower than create database "localhost:crypt_test" user "SYSDBA" password "mas

[Firebird-devel] [FB-Tracker] Created: (CORE-6421) Parameter in offset expression in LAG, LEAD, NTH_VALUE window functions requires explicit cast to BIGINT or INTEGER

2020-10-19 Thread Mark Rotteveel (JIRA)
Parameter in offset expression in LAG, LEAD, NTH_VALUE window functions requires explicit cast to BIGINT or INTEGER --- Key: CORE-6421 URL: http://trac

[Firebird-devel] [FB-Tracker] Created: (CORE-6420) ROWS performance gets worse the larger the dataset

2020-10-19 Thread Rand Random (JIRA)
ROWS performance gets worse the larger the dataset -- Key: CORE-6420 URL: http://tracker.firebirdsql.org/browse/CORE-6420 Project: Firebird Core Issue Type: Bug Affects Versions: 3.0.6

[Firebird-devel] PostgreSQL 13 can efficiently handle duplicate data in B-tree indexes, the standard database index.

2020-10-19 Thread marius adrian popa
>From pg release notes https://www.postgresql.org/about/news/postgresql-13-released-2077/ https://www.postgresql.org/docs/13/btree-implementation.html#BTREE-DEDUPLICATION ps: I don't know if Firebird can be optimized in a similar Firebird-Devel mailing list, web interface at https://lists.sourcef