firebird icon indicating copy to clipboard operation
firebird copied to clipboard

Published 20 hours ago • verified publisher icon FirebirdSQL

Data pages of newly gbak restored databases should marked as "swept" [CORE6164]

Open firebird-automations opened this issue 6 years ago • 5 comments

Submitted by: Omacht András (aomacht)

Votes: 2

Vlad said at the conference in Berlin it is possible the improve gbak and the engine to set swept flag on all data pages while the database is created by gbak. This solution would make the gfix -sweep first run much faster.

firebird-automations avatar Oct 21 '19 10:10 firebird-automations

Commented by: Sean Leyne (seanleyne)

Changed the Summary for readability.

firebird-automations avatar Oct 21 '19 18:10 firebird-automations

Modified by: Sean Leyne (seanleyne)

summary: While database is create by gbak it should set swept flag on all data pages => Data pages of newly gbak restored databases should marked as "swept"

firebird-automations avatar Oct 21 '19 18:10 firebird-automations

Modified by: @hvlad

assignee: Vlad Khorsun [ hvlad ]

firebird-automations avatar Oct 21 '19 22:10 firebird-automations

Can you please consider implementing this? Right now production database suffers big disk performance for multiple hours when sweep runs for the first time after restore (500+GB db).

pbhofstede2 avatar Apr 01 '25 07:04 pbhofstede2

Looking what can be done.

hvlad avatar Apr 14 '25 06:04 hvlad