Re: odd postgresql performance (excessive lseek)

From: Merlin Moncure <mmoncure(at)gmail(dot)com>
To: Jon Nelson <jnelson+pgsql(at)jamponi(dot)net>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: odd postgresql performance (excessive lseek)
Date: 2010-10-19 13:25:20
Message-ID: AANLkTimUp6VmXRD2-U4Gfp1L5KS_fq3OJfOMHgE6k6oz@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

On Tue, Oct 19, 2010 at 9:10 AM, Jon Nelson <jnelson+pgsql(at)jamponi(dot)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

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Jon Nelson 2010-10-19 13:38:30 Re: odd postgresql performance (excessive lseek)
Previous Message Jon Nelson 2010-10-19 13:10:47 Re: odd postgresql performance (excessive lseek)