rodrigogoncalves wrote:

>
> we have a client with a database showing the following information on
> gstat:
>
> Database header page information:
> Oldest transaction 1316722
> Oldest active 1316723
> Oldest snapshot 1315494
> Next transaction 1439471
>
> This machine (running latest FB SS & Fedora Core 3) show an absurd
> memory usage by the fbserver process:
>
> PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND
> 581 root 16 0 541m 352m 4972 S 0.7 70.2 29:25.33 fbserver

One thing to note is that the difference between the oldest snapshot
transaction and the next is nearly 124,000. That's a lot. Your client
has a snapshot transaction lurking around somewhere that's blocking
garbage collection and holding down a large list of "interesting"
transactions.

Regards,


Ann