Tom Lane <[EMAIL PROTECTED]> wrote:
> I said nothing about expired tuples. The point of not freezing is to
> preserve information about the insertion time of live tuples.
I don't know what good it will do -- for debugging?
Why don't you use CURRENT_TIMESTAMP?
> And your
> test case is unconvincing, because no sane DBA would run with such a
> small value of vacuum_freeze_min_age.
I intended to use the value for an accelerated test.
The penalties of freeze are divided for the long term in normal use,
but we surely suffer from them by bits.
Regards,
---
ITAGAKI Takahiro
NTT Open Source Software Center
---------------------------(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
