Re: [Firebird-devel] Partitioning (was: Tablespaces proposal)

2021-10-13 Thread Pavel Cisar
Hi, Dne 12. 10. 21 v 15:21 Dimitry Sibiryakov napsal(a):   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, only filter for whole tables and (since it is already

Re: [Firebird-devel] Partitioning (was: Tablespaces proposal)

2021-10-12 Thread Dmitry Yemanov
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

Re: [Firebird-devel] Partitioning (was: Tablespaces proposal)

2021-10-12 Thread Dimitry Sibiryakov
Dmitry Yemanov wrote 12.10.2021 15:02: Partition is a page set. Different page sets may be surely stored inside a single database file, but they may also be stored in different files. It makes a lot of sense to nbackup only some partition(s), or store them on slow drives, etc -- the same as