On 28 Září 2013, 23:25, Edson Richter wrote:
> Em 28/09/2013 18:12, Tomas Vondra escreveu:
>> Do you realize the counters in pg_stat_database (temp_files, temp_bytes)
>> are counters tracking all the temp files created since the last reset of
>> the stats (possible since the cluster was created)?
>>
>> So these values only increment (and it's meant to behave like that). BTW
>> this is true for most values in the stats catalogs, so there's nothing
>> like "current stats" - to get something like that you need to get two
>> snapshots and subtract them (to get the delta).
>>
>> Tomas
>
> Ah, ok! One more lesson learned...
> I would expect stats being current of, or up-to-date after a vacuum
> analyze...
> Thank you all very much.
Vacuum has nothing to do with this. The temp files are removed immediately
(by the particular operation that created them) once not needed anymore.
Unless something goes terribly wrong, of course ...
Tomas