Re: stat /etc/localtime 38000 times on startup? - Mailing list pgsql-hackers

From Magnus Hagander
Subject Re: stat /etc/localtime 38000 times on startup?
Date
Msg-id 6BCB9D8A16AC4241919521715F4D8BCE92E98B@algol.sollentuna.se
Whole thread Raw
In response to stat /etc/localtime 38000 times on startup?  (Andrew Dunstan <andrew@dunslane.net>)
List 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


pgsql-hackers by date:

Previous
From: "Alon Goldshuv"
Date:
Subject: Libpq COPY optimization
Next
From: Andrew Dunstan
Date:
Subject: plperl header fix and rationalisation