Re: Time to run initdb is mostly figure-out-the-timezone work

From: Alvaro Herrera <alvherre(at)commandprompt(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-hackers(at)postgreSQL(dot)org
Subject: Re: Time to run initdb is mostly figure-out-the-timezone work
Date: 2009-12-18 17:49:04
Message-ID: 20091218174904.GD4055@alvh.no-ip.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Tom Lane wrote:
> 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.

Wow, I can reproduce this (11-12 secs when no TZ versus 5 when TZ is
defined). I'd never noticed because I normally have TZ set; but yes I
agree that this is worthwhile.

I notice that most of the difference is system time ... I imagine we do
a lot of syscalls to guess the timezone.

--
Alvaro Herrera http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Kevin Grittner 2009-12-18 17:49:15 Re: Update on true serializable techniques in MVCC
Previous Message Tom Lane 2009-12-18 17:45:11 Re: Distinguish view and table problem