Thread: number of opened files

number of opened files

From
JEANARTHUR@EUROVOX.FR
Date:
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





Re: number of opened files

From
Tom Lane
Date:
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