Tom Lane wrote:
So there's some Heisenberg effect here. However, I don't think there can be much doubt that on a machine that is just booting (and has surely got none of these files in cache) the search through share/postgresql/timezone could take a few seconds. Hindsight is always 20/20 ;-)
Something is surely wrong in the timezone lib, though: [EMAIL PROTECTED] inst]$ grep /etc/localtime strace.out | wc -l 38073 cheers andrew ---------------------------(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