Re: Postgres slower than MS ACCESS

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Postgres slower than MS ACCESS
Дата
Msg-id 19881.1140039411@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Postgres slower than MS ACCESS  ("Jay Greenfield" <jag@timberline.ca>)
Список pgsql-performance
"Jay Greenfield" <jag@timberline.ca> writes:
> I did a run with checkpoint_segments @ 30 (from 3 in 4.35 min run) and
> posted a time of 6.78 minutes.  Any idea why this would increase the time?

The first time through might take longer while the machine creates empty
xlog segment files (though I'd not have expected a hit that big).  Once
it's fully populated pg_xlog it'll just recycle the files, so you might
find that a second try is faster.

            regards, tom lane

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

Предыдущее
От: Gary Doades
Дата:
Сообщение: Re: Strange Create Index behaviour
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Strange Create Index behaviour