Skip site navigation (1) Skip section navigation (2)

PostgreSQL BugTool Submission

From: pgsql-bugs(at)postgresql(dot)org
To: pgsql-bugs(at)postgresql(dot)org
Subject: PostgreSQL BugTool Submission
Date: 2000-08-24 04:49:03
Message-ID: 200008240449.e7O4n3603230@hub.org (view raw or flat)
Thread:
Lists: pgsql-bugs
Doug Mitchell (pgsql(at)dougmitchell(dot)com) reports a bug with a severity of 3
The lower the number the more severe it is.

Short Description
Excessive seeking by backend

Long Description
The backend call lseek much more often than it has to.  The storage manage should not do either of the following:

1.  Repetetive seeks on the same location without any intervening read or write.

2.  Seeking to the next block to read when it is already the current
location.

These excessive system calls hurt performance by forcing a full context switch to kernel mode everytime.

Sample Code
I did a combination of sequential scans, index scans, and joins while watching the backend with strace under Linux 2.2.  The results are really rather surprising.

No file was uploaded with this report


Responses

pgsql-bugs by date

Next:From: Tom LaneDate: 2000-08-24 05:16:23
Subject: Re: PostgreSQL BugTool Submission
Previous:From: Tom LaneDate: 2000-08-24 04:37:16
Subject: Re: PostgreSQL BugTool Submission

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group