Re: odd postgresql performance (excessive lseek)

Поиск
Список
Период
Сортировка
От Merlin Moncure
Тема Re: odd postgresql performance (excessive lseek)
Дата
Msg-id AANLkTimUp6VmXRD2-U4Gfp1L5KS_fq3OJfOMHgE6k6oz@mail.gmail.com
обсуждение исходный текст
Ответ на Re: odd postgresql performance (excessive lseek)  (Jon Nelson <jnelson+pgsql@jamponi.net>)
Ответы Re: odd postgresql performance (excessive lseek)  (Jon Nelson <jnelson+pgsql@jamponi.net>)
Список pgsql-performance
On Tue, Oct 19, 2010 at 9:10 AM, Jon Nelson <jnelson+pgsql@jamponi.net> wrote:
> No replies?
>
> This is another situation where using pread would have saved a lot of
> time and sped things up a bit, but failing that, keeping track of the
> file position ourselves and only lseek'ing when necessary would also
> help. Postgresql was spending 37% of it's time in redundant lseek!

37% of cpu time?  Is that according to strace -T? how did you measure it?

merlin

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

Предыдущее
От: Jon Nelson
Дата:
Сообщение: Re: odd postgresql performance (excessive lseek)
Следующее
От: Jon Nelson
Дата:
Сообщение: Re: odd postgresql performance (excessive lseek)