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

From Tom Lane
Subject Re: stat /etc/localtime 38000 times on startup?
Date
Msg-id 26218.1136749643@sss.pgh.pa.us
Whole thread Raw
In response to stat /etc/localtime 38000 times on startup?  (Andrew Dunstan <andrew@dunslane.net>)
List pgsql-hackers
Andrew Dunstan <andrew@dunslane.net> writes:
> 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?

glibc's strftime does that if you don't have a TZ value set in the
postmaster's environment.

http://archives.postgresql.org/pgsql-hackers/2005-10/msg00884.php
        regards, tom lane


pgsql-hackers by date:

Previous
From: Andrew Dunstan
Date:
Subject: Re: plperl vs LC_COLLATE (was Re: Possible savepoint bug)
Next
From: Tom Lane
Date:
Subject: Re: Libpq COPY optimization