12.10.2021 16:21, Dimitry Sibiryakov wrote:
INSERT:
Nothing except time wasting to calculation partitioning key and
creation of a new partition if necessary (ignorable).
Slightly faster inserts into indices.
UPDATE:
DELETE:
Faster index GC after them.
BACKUP:
Backup of separate partition is something nobody asked for so far. At
least I cannot remember a ticket for gbak accepting filter condition
inside of a table
It makes zero sense for gbak, because it restores the database as a
whole and cannot append/replace records in existing database. But it may
be possible with partitions in different files and nbackup.
Dmitry
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
