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

Port Bug Report: Backend lseeks needlessly

From: Unprivileged user <nobody>
To: pgsql-ports(at)postgresql(dot)org
Subject: Port Bug Report: Backend lseeks needlessly
Date: 1999-12-02 05:31:54
Message-ID: 199912020531.AAA73756@hub.org (view raw or flat)
Thread:
Lists: pgsql-ports
============================================================================
                        POSTGRESQL BUG REPORT TEMPLATE
============================================================================


Your name               : Doug Mitchell
Your email address      : doug(at)mitchcraft(dot)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.

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


pgsql-ports by date

Next:From: Patrice TROGNONDate: 1999-12-02 11:08:47
Subject: PostgreSQL on Windows NT 4 ?
Previous:From: Walfredo MarananDate: 1999-12-01 18:56:42
Subject: Question about code

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