Re: stat /etc/localtime 38000 times on startup?

From: "Magnus Hagander" <mha(at)sollentuna(dot)net>
To: "Andrew Dunstan" <andrew(at)dunslane(dot)net>, "PostgreSQL-development" <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: stat /etc/localtime 38000 times on startup?
Date: 2006-01-08 14:05:15
Message-ID: 6BCB9D8A16AC4241919521715F4D8BCE92E98B@algol.sollentuna.se
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

> I just traced starting up a postmaster, and got over 38000
> lines like this:
>
> stat64("/etc/localtime", {st_mode=S_IFREG|0644,
> st_size=1267, ...}) = 0
>
> I assume it comes from the timezone library, but it seems
> highly inefficient. Anyone know why we might get this?

Without digging into details, I would guess htat comes from the probing
of available timezones to find one that matches the current one. We do a
whole lot of setting/resetting the TZ there - but only during postmaster
startup.

//Magnus

Browse pgsql-hackers by date

  From Date Subject
Next Message Andrew Dunstan 2006-01-08 14:37:51 plperl header fix and rationalisation
Previous Message Alon Goldshuv 2006-01-08 14:00:04 Libpq COPY optimization