MG wrote:
>> I don't think that there were any changes to the template databases.
>>
>> You detected a difference in age(datfrozenxid) - try selecting
>> datfrozenxid itself and you will probably see that it does not
>> change over time.
>
> Yes there are changes.
> db1, db2 and template1 has been vacuumed over night, not template0.
> 20.02.07 datname - (12) age - (4)
> 1 db1 1.075.878.187
> 2 db2 1.075.847.556
> 3 template1 1.976.569.889
> 4 template0 1.976.569.889
>
>
>
>
> 21.02.07 datname - (12) age - (4)
> 1 db1 1.074.758.205
> 2 db2 1.074.728.832
> 3 template1 1.074.728.720
> 4 template0 1.978.965.587
What do you mean by (12) age - (4)?
I told you to select datfrozenxid and not age(datfrozenxid).
Try and vacuum ALL databases.
Yours,
Laurenz Albe
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
