============================================================================
POSTGRESQL BUG REPORT TEMPLATE
============================================================================


Your name : Doug Mitchell
Your email address : doug@mitchcraft.com

Category : runtime: back-end
Severity : non-critical

Summary: Backend lseeks needlessly

System Configuration
--------------------
Operating System : RedHat Linux 6.1

PostgreSQL version : 6.5.2

Compiler used : egcs-2.91.66

Hardware:
---------
i686-pc-linux-gnu

Versions of other tools:
------------------------


--------------------------------------------------------------------------

Problem Description:
--------------------
Had the backend processs simple one-record select
and update queries using index scans and watched
it with strace.

--------------------------------------------------------------------------

Test Case:
----------
Attach to running backend with
strace -p pid
and watch all the lseeks

strace -c -p pid
and count lseeks vs reads and writes



--------------------------------------------------------------------------

Solution:
---------
Probably could be handled in the storage manager,
so at least a slow system call is prevented, but
is should be fixed in the upper layers too.

--------------------------------------------------------------------------

Search Discussions

Related Discussions

Discussion Navigation
viewthread | post
Discussion Overview
grouppgsql-ports @
categoriespostgresql
postedDec 2, '99 at 5:31a
activeDec 2, '99 at 5:31a
posts1
users1
websitepostgresql.org
irc#postgresql

1 user in discussion

Doug Mitchell: 1 post

People

Translate

site design / logo © 2022 Grokbase