Обсуждение: number of opened files

Hello,

We use PG 7.3.2 and we noticed that at 12 PM and 12 AM (when we
do a vaccumdb -v -a -z) , number of open files suddenly decrease (for
example from 7300 open files to 4500).

Is it normal that when we do a vacuumdb, the number of open files
decrease ?


Thank you !


Jean-Arthur Silve
EuroVox
4, Place Félix Eboué
75583 Paris Cedex 12
T : +33 1 44670505
F : +33 1 44670519

JEANARTHUR@EUROVOX.FR writes:
> Is it normal that when we do a vacuumdb, the number of open files
> decrease ?

Doesn't surprise me --- that'd be a likely result of the relcache
flushes that vacuum will trigger.

            regards, tom lane