Geek Answers Handbook

Does Firebird Defrag? If so, how is a clustered index?

I saw several (literally, only a few) links and nothing in the documentation that tells about clustering with Firebird that this can be done.

Then I shot the CLUSTER command for Firebird for the moon on this issue ? but the defendant told me that Firebird has no clustered indexes at all, so now I'm really confused.

Is Firebird physically sorting data at all? If so, can it be ordered with any key, not just the primary one, and enable or disable clustering / defragmentation so that it only does this during downtime?

If this is not so, this is not a performance hit, since there will be more time on the disk to collect separate lines, which, naturally, should be next to each other?

(DB noob)

MVCC

I found out that Firebird is based on MVCC, so the old data is not actually overwritten until "sweep". I love it!

Again, I can't find much, but it seems a real shame that the data will not be defragmented according to the key.

This states that the database pages are defragmented, but does not provide any further explanation.

+4
source share
2 answers

Firebird . , , , . , . . , , , . , , , .

, , . , . . , , , . , , , , , .

Firebird , , . , . . , Firebird Multi-Version Concurrency Control, , , Firebird , . , , , , Firebird . . , Firebird , . "Sweep", . Sweep , , . , , , .

,

Firebird,

BTW - , , Firebird , , . , 16 , , , .

+10

70% ( , gbak -use_all_space-), , . , . , "".

, Firebird . , , , , !

+2

More articles:


All Articles