Re: odd postgresql performance (excessive lseek)

From: Jon Nelson <jnelson+pgsql(at)jamponi(dot)net>
To: pgsql-performance(at)postgresql(dot)org
Subject: Re: odd postgresql performance (excessive lseek)
Date: 2010-10-19 13:10:47
Message-ID: AANLkTin3qV-dPeu771VLGmbiPPpeHz2oT=0t6CPtaSeS@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Merlin Moncure 2010-10-19 13:25:20 Re: odd postgresql performance (excessive lseek)
Previous Message Eric Comeau 2010-10-19 11:23:57 Re: Help with duration of statement: EXECUTE <unnamed> [PREPARE: COMMIT]