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

Поиск
Список
Период
Сортировка
От Alvaro Herrera
Тема Re: Time to run initdb is mostly figure-out-the-timezone work
Дата
Msg-id 20091218174904.GD4055@alvh.no-ip.org
обсуждение исходный текст
Ответ на Time to run initdb is mostly figure-out-the-timezone work  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: Time to run initdb is mostly figure-out-the-timezone work  (Tom Lane <tgl@sss.pgh.pa.us>)
Список 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


В списке pgsql-hackers по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Distinguish view and table problem
Следующее
От: "Kevin Grittner"
Дата:
Сообщение: Re: Update on true serializable techniques in MVCC