--- In firebird-support@yahoogroups.com, "mikcaau" <macomp@s...>
wrote:

>
> --- In firebird-support@yahoogroups.com, "mysha_cz" <mysha_cz@y...>

wrote:

> >
> > Please can you help me?
> > I have this problem. My DB (running on FB 1.5, Superserver) is

growing

> > too fast.
> > The problem is in massive update in records, which is necessary

to do.

> > When I look at table statistics, I see a lot of old versions of
> > records. For example records are 25000, old versions 75000. I

don't

> > know why there are still records of all generations. I would like

to

> > know: exist some parameter of server, or exist some transaction

setting

> > which reserve only one old generation of records?
> >
> Run GStat and post results.
> Sounds as if you have transactions kept open.
> mick
>

This is result of GStat:
1)db part
Database header page information:
Flags 0
Checksum 12345
Generation 709
Page size 4096
ODS version 10.1
Oldest transaction 527
Oldest active 528
Oldest snapshot 528
Next transaction 703
Bumped transaction 1
Sequence number 0
Next attachment ID 0
Implementation ID 16
Shadow count 0
Page buffers 0
Next header page 0
Database dialect 3
Creation date Nov 24, 2005 22:52:32
Attributes

Variable header data:
Sweep interval: 20000
*END*

2) table part
RIDES (148)
Primary pointer page: 360, Index root page: 361
Data pages: 1266, data page slots: 1266, average fill: 95%
Fill distribution:
0 - 19% = 0
20 - 39% = 1
40 - 59% = 0
60 - 79% = 1
80 - 99% = 1264

Index INDEXRIDES (0)
Depth: 2, leaf buckets: 47, nodes: 27386
Average data length: 0.00, total dup: 23223, max dup: 305
Fill distribution:
0 - 19% = 0
20 - 39% = 1
40 - 59% = 0
60 - 79% = 0
80 - 99% = 46

Index RDB$PRIMARY2 (1)
Depth: 3, leaf buckets: 313, nodes: 27386
Average data length: 39.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 312