Re: odd postgresql performance (excessive lseek) - Mailing list pgsql-performance

From Jon Nelson
Subject Re: odd postgresql performance (excessive lseek)
Date
Msg-id AANLkTin3qV-dPeu771VLGmbiPPpeHz2oT=0t6CPtaSeS@mail.gmail.com
Whole thread Raw
In response to odd postgresql performance (excessive lseek)  (Jon Nelson <jnelson+pgsql@jamponi.net>)
Responses Re: odd postgresql performance (excessive lseek)
Re: odd postgresql performance (excessive lseek)
List 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 by date:

Previous
From: Eric Comeau
Date:
Subject: Re: Help with duration of statement: EXECUTE [PREPARE: COMMIT]
Next
From: Merlin Moncure
Date:
Subject: Re: odd postgresql performance (excessive lseek)