Re: odd postgresql performance (excessive lseek)

Поиск
Список
Период
Сортировка
От Jon Nelson
Тема Re: odd postgresql performance (excessive lseek)
Дата
Msg-id AANLkTin3qV-dPeu771VLGmbiPPpeHz2oT=0t6CPtaSeS@mail.gmail.com
обсуждение исходный текст
Ответ на odd postgresql performance (excessive lseek)  (Jon Nelson <jnelson+pgsql@jamponi.net>)
Ответы Re: odd postgresql performance (excessive lseek)  (Merlin Moncure <mmoncure@gmail.com>)
Re: odd postgresql performance (excessive lseek)  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-performance
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!

--
Jon

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

Предыдущее
От: Eric Comeau
Дата:
Сообщение: Re: Help with duration of statement: EXECUTE [PREPARE: COMMIT]
Следующее
От: Merlin Moncure
Дата:
Сообщение: Re: odd postgresql performance (excessive lseek)