Joshua Tolley <eggyk...@gmail.com> writes: > On Fri, Dec 18, 2009 at 06:20:39PM +0100, Guillaume Lelarge wrote: >> Le 18/12/2009 18:07, Tom Lane a écrit : >>> On current Fedora 11, there is a huge difference in initdb time if you >>> have TZ set versus if you don't: I get about 18 seconds versus less than >>> four.
>> I have the exact same issue: > For whatever it's worth, I get it too, on Ubuntu 9.04... ~4s without TZ vs. > ~1.8s with TZ. BTW, I just realized that it makes a difference that I customarily use the configure option --with-system-tzdata=/usr/share/zoneinfo on that machine. I do it mainly because it saves a few seconds during "make install", but also because Red Hat's PG packages use that option so I want to test it regularly. The impact of this is that the TZ search also has to scan through a bunch of leap-second-aware timezone files, which are not present in a default PG build's timezone tree. So that probably explains why I see a 4x slowdown while you get more like 2x. Still, it seems worth doing something about, if it's as easy as a one-line addition. regards, tom lane -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers