Firebird doesn't support schemas.
This is the main reason I am replacing it by PostgreSQL in all my projects.
In versions prior to 3.0, there is a limit on SQL instruction size, what
makes it hard to use with frameworks like Hibernate, which tends to
generate huge SQL instructions.
But this is sol
eThreshold
>
>
> On Thursday, May 24, 2018, 8:30:09 AM CDT, Fabiano Bonin
> fabiano.bo...@personalsoft.com.br [firebird-support]
> wrote:
>
>
>
>
> Hi, Omacht!
>
> Indeed, it needs a sweep.
>
> There a scheduled script that runs every night to sweep th
Hi, Omacht!
Indeed, it needs a sweep.
There a scheduled script that runs every night to sweep the database, and
it broke with FB3 upgrade.
I fixed the script and it will run this night.
But, do you think the memory exaustion can be related to this issue?
Regards,
Fabiano
2018-05-24 2:47 G
> On Wednesday, May 23, 2018, 9:29:30 AM CDT, Fabiano Bonin
> fabiano.bo...@personalsoft.com.br [firebird-support] <
> firebird-support@yahoogroups.com> wrote:
>
>
>
>
> Hi, Thomas. It is zero. I presume in this case it uses the system default,
> right?
>
>
Hi, Thomas. It is zero. I presume in this case it uses the system default,
right?
Regards,
Fabiano
Database header page information:
Flags 0
Generation 62390727
System Change Number0
Page size 4096
ODS versi
Hi,
I have a Debian 9 Linux server with 8GB of memory, a database with 30GB,
page size 4KB, and Firebird 3.0.3 running in superserver mode and about
150-200 concurrent connections.
In my firebird.conf I have changed the following properties:
DefaultDbCachePages = 524288 # 2GB
TempCacheLimit = 10