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

Possible BUG in -head with stats

From: "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com>
To: PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: Possible BUG in -head with stats
Date: 2007-03-01 06:36:12
Message-ID: 45E6745C.9010005@commandprompt.com (view raw or flat)
Thread:
Lists: pgsql-hackers
Hello,

O.k. no one seemed interested in our 8.2 issues, so I thought i would
test on -head ;)

jd(at)scratch:/tmp/pg$ strace -c -p 3545
Process 3545 attached - interrupt to quit
Process 3545 detached
% time     seconds  usecs/call     calls    errors syscall
------ ----------- ----------- --------- --------- ----------------
 59.45    0.178412           3     70176     10128 poll
 22.68    0.068083           7     10294           rename
 12.05    0.036158           4     10294           open
  2.98    0.008929           1     10294           close
  1.68    0.005051           0     60040           recvfrom
  0.65    0.001954           0     10294           setitimer
  0.46    0.001386           0     20588           write
  0.03    0.000090           0     10294           mmap
  0.02    0.000065           0     10294           munmap
  0.00    0.000000           0     10294           fstat
  0.00    0.000000           0         1           brk
  0.00    0.000000           0     10294     10128 rt_sigreturn
  0.00    0.000000           0     10302           getppid
------ ----------- ----------- --------- --------- ----------------
100.00    0.300128                243459     20256 total


THe rename is being called 10294 times over 1 minute 56 seconds. This is
on the same machine and using the same test as mention here:

http://archives.postgresql.org/pgsql-hackers/2007-02/msg01902.php

Joshua D. Drake
-- 

      === The PostgreSQL Company: Command Prompt, Inc. ===
Sales/Support: +1.503.667.4564 || 24x7/Emergency: +1.800.492.2240
Providing the most comprehensive  PostgreSQL solutions since 1997
             http://www.commandprompt.com/

Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate
PostgreSQL Replication: http://www.commandprompt.com/products/


pgsql-hackers by date

Next:From: Zoltan BoszormenyiDate: 2007-03-01 07:04:53
Subject: Re: Is there a way to run heap_insert() AFTER ExecInsertIndexTuples() ?
Previous:From: Tom LaneDate: 2007-03-01 06:17:03
Subject: Re: Resumable vacuum proposal and design overview

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