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 |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
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.
--------------------------------------------------------------------------
From | Date | Subject | |
---|---|---|---|
Next Message | Patrice TROGNON | 1999-12-02 11:08:47 | PostgreSQL on Windows NT 4 ? |
Previous Message | Walfredo Maranan | 1999-12-01 18:56:42 | Question about code |