Thread

1. PostgreSQL BugTool Submission

   PostgreSQL Bugs List <pgsql-bugs@postgresql.org> — 2000-08-24T04:49:03Z

   Doug Mitchell (pgsql@dougmitchell.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
   
   
   

2. Re: PostgreSQL BugTool Submission

   Tom Lane <tgl@sss.pgh.pa.us> — 2000-08-24T05:16:23Z

   pgsql-bugs@postgresql.org writes:
   > The backend call lseek much more often than it has to.
   
   Denis Perchine fixed this a couple of months ago.  You might care to
   repeat your experiments with current sources (see our CVS server, or
   the nightly snapshot tarball on our FTP server).  If there's still
   a problem we'd like to know before it's too late to tweak 7.1 ...
   
   			regards, tom lane