Thousands of semops for every i/o

From: "Jeffrey W(dot) Baker" <jwbaker(at)acm(dot)org>
To: pgsql-general(at)postgresql(dot)org
Subject: Thousands of semops for every i/o
Date: 2003-06-09 17:27:58
Message-ID: 1055179678.5240.18.camel@noodles
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-patches

This is the strace of a process which is deleting rows from four tables,
inside a transaction, one row at a time. There are a lot of semops for
every i/o. There are about 30 connections to this database currently.
I thought deletes in a transaction just flew along in Pg, because they
simply wrote the deleted transaction ID on the record. It used to work
fine in my previous locally-built 7.2 on Debian, but this is 7.2.2 on
SuSE Enterprise Server 8.2.

Is there any way to prevent this?

semop(15106509, 0x7fbfffec60, 1) = 0
semop(15106509, 0x7fbfffec30, 1) = 0
semop(15106509, 0x7fbfffec40, 1) = 0
semop(15106509, 0x7fbfffec50, 1) = 0
semop(15106509, 0x7fbfffec60, 1) = 0
semop(15106509, 0x7fbfffec30, 1) = 0
semop(15106509, 0x7fbfffec40, 1) = 0
semop(15106509, 0x7fbfffec50, 1) = 0
semop(15106509, 0x7fbfffec60, 1) = 0
semop(15106509, 0x7fbfffec30, 1) = 0
semop(15106509, 0x7fbfffec40, 1) = 0
semop(15106509, 0x7fbfffec50, 1) = 0
semop(15106509, 0x7fbfffec60, 1) = 0
semop(0, 0x7fbfffebf0, 1) = 0
semop(0, 0x7fbfffec00, 1) = 0
semop(11862378, 0x7fbfffeb80, 1) = 0
semop(11862378, 0x7fbfffeb90, 1) = 0
semop(0, 0x7fbfffebc0, 1) = 0
semop(0, 0x7fbfffebd0, 1) = 0
read(58, "\4\0\0\0(\32\212\206\v\0\0\0\360\1 \2\0 \0 \300\237|\0"...,
8192) = 8192
semop(0, 0x7fbfffebf0, 1) = 0
semop(0, 0x7fbfffec00, 1) = 0
semop(11862378, 0x7fbfffec00, 1) = 0
semop(11862378, 0x7fbfffec10, 1) = 0
semop(0, 0x7fbfffec10, 1) = 0
semop(0, 0x7fbfffec20, 1) = 0
semop(11862378, 0x7fbfffec30, 1) = 0
semop(11862378, 0x7fbfffec40, 1) = 0
semop(11862378, 0x7fbfffec50, 1) = 0
semop(11862378, 0x7fbfffec60, 1) = 0
semop(0, 0x7fbfffecb0, 1) = 0
semop(0, 0x7fbfffecc0, 1) = 0
semop(0, 0x7fbfffecd0, 1) = 0
semop(0, 0x7fbfffece0, 1) = 0
semop(11862378, 0x7fbfffec30, 1) = 0
semop(11862378, 0x7fbfffec40, 1) = 0
semop(11862378, 0x7fbfffec50, 1) = 0
semop(11862378, 0x7fbfffec60, 1) = 0
semop(11862378, 0x7fbfffec30, 1) = 0
semop(11862378, 0x7fbfffec40, 1) = 0
semop(11862378, 0x7fbfffec50, 1) = 0
semop(11862378, 0x7fbfffec60, 1) = 0
semop(11862378, 0x7fbfffec30, 1) = 0
semop(11862378, 0x7fbfffec40, 1) = 0
semop(11862378, 0x7fbfffec50, 1) = 0
semop(11862378, 0x7fbfffec60, 1) = 0
semop(11862378, 0x7fbfffec30, 1) = 0
semop(11862378, 0x7fbfffec40, 1) = 0
semop(11862378, 0x7fbfffec50, 1) = 0
semop(11862378, 0x7fbfffec60, 1) = 0
semop(11862378, 0x7fbfffec30, 1) = 0
semop(11862378, 0x7fbfffec40, 1) = 0
semop(11862378, 0x7fbfffec50, 1) = 0
semop(11862378, 0x7fbfffec60, 1) = 0
semop(11862378, 0x7fbfffec30, 1) = 0
semop(11862378, 0x7fbfffec40, 1) = 0
semop(11862378, 0x7fbfffec50, 1) = 0
semop(11862378, 0x7fbfffec60, 1) = 0
semop(11862378, 0x7fbfffec30, 1) = 0
semop(11862378, 0x7fbfffec40, 1) = 0
semop(11862378, 0x7fbfffec50, 1) = 0
semop(11862378, 0x7fbfffec60, 1) = 0
semop(11862378, 0x7fbfffec30, 1) = 0
semop(11862378, 0x7fbfffec40, 1) = 0
semop(11862378, 0x7fbfffec50, 1) = 0
semop(11862378, 0x7fbfffec60, 1) = 0
semop(11862378, 0x7fbfffec30, 1) = 0
semop(11862378, 0x7fbfffec40, 1) = 0
semop(11862378, 0x7fbfffec50, 1) = 0
semop(11862378, 0x7fbfffec60, 1) = 0
semop(11862378, 0x7fbfffec30, 1) = 0
semop(11862378, 0x7fbfffec40, 1) = 0
semop(11862378, 0x7fbfffec50, 1) = 0
semop(11862378, 0x7fbfffec60, 1) = 0
semop(11862378, 0x7fbfffec30, 1) = 0
semop(11862378, 0x7fbfffec40, 1) = 0
semop(11862378, 0x7fbfffec50, 1) = 0
semop(11862378, 0x7fbfffec60, 1) = 0
semop(11862378, 0x7fbfffec30, 1) = 0
semop(11862378, 0x7fbfffec40, 1) = 0
semop(11862378, 0x7fbfffec50, 1) = 0
semop(11862378, 0x7fbfffec60, 1) = 0
semop(11862378, 0x7fbfffec30, 1) = 0
semop(11862378, 0x7fbfffec40, 1) = 0
semop(11862378, 0x7fbfffec50, 1) = 0
semop(11862378, 0x7fbfffec60, 1) = 0
semop(11862378, 0x7fbfffec30, 1) = 0
semop(11862378, 0x7fbfffec40, 1) = 0
semop(11862378, 0x7fbfffec50, 1) = 0
semop(11862378, 0x7fbfffec60, 1) = 0
semop(11862378, 0x7fbfffec30, 1) = 0
semop(11862378, 0x7fbfffec40, 1) = 0
semop(11862378, 0x7fbfffec50, 1) = 0
semop(11862378, 0x7fbfffec60, 1) = 0
semop(11862378, 0x7fbfffec30, 1) = 0
semop(11862378, 0x7fbfffec40, 1) = 0
semop(11862378, 0x7fbfffec50, 1) = 0
semop(11862378, 0x7fbfffec60, 1) = 0
semop(11862378, 0x7fbfffec30, 1) = 0
semop(11862378, 0x7fbfffec40, 1) = 0
semop(11862378, 0x7fbfffec50, 1) = 0
semop(11862378, 0x7fbfffec60, 1) = 0
semop(11862378, 0x7fbfffec30, 1) = 0
semop(11862378, 0x7fbfffec40, 1) = 0
semop(11862378, 0x7fbfffec50, 1) = 0
semop(11862378, 0x7fbfffec60, 1) = 0
semop(11862378, 0x7fbfffec30, 1) = 0
semop(11862378, 0x7fbfffec40, 1) = 0
semop(11862378, 0x7fbfffec50, 1) = 0
semop(11862378, 0x7fbfffec60, 1) = 0
semop(11862378, 0x7fbfffec30, 1) = 0
semop(11862378, 0x7fbfffec40, 1) = 0
semop(11862378, 0x7fbfffec50, 1) = 0
semop(11862378, 0x7fbfffec60, 1) = 0
semop(11862378, 0x7fbfffec30, 1) = 0
semop(11862378, 0x7fbfffec40, 1) = 0
semop(11862378, 0x7fbfffec50, 1) = 0
semop(11862378, 0x7fbfffec60, 1) = 0
semop(11862378, 0x7fbfffec30, 1) = 0
semop(11862378, 0x7fbfffec40, 1) = 0
semop(11862378, 0x7fbfffec50, 1) = 0
semop(11862378, 0x7fbfffec60, 1) = 0
semop(11862378, 0x7fbfffec30, 1) = 0
semop(11862378, 0x7fbfffec40, 1) = 0
semop(11862378, 0x7fbfffec50, 1) = 0
semop(11862378, 0x7fbfffec60, 1) = 0
semop(11862378, 0x7fbfffec30, 1) = 0
semop(11862378, 0x7fbfffec40, 1) = 0
semop(11862378, 0x7fbfffec50, 1) = 0
semop(11862378, 0x7fbfffec60, 1) = 0
semop(11862378, 0x7fbfffec30, 1) = 0
semop(11862378, 0x7fbfffec40, 1) = 0
semop(11862378, 0x7fbfffec50, 1) = 0
semop(11862378, 0x7fbfffec60, 1) = 0
semop(11862378, 0x7fbfffec30, 1) = 0
semop(11862378, 0x7fbfffec40, 1) = 0
semop(11862378, 0x7fbfffec50, 1) = 0
semop(11862378, 0x7fbfffec60, 1) = 0
semop(11862378, 0x7fbfffec30, 1) = 0
semop(11862378, 0x7fbfffec40, 1) = 0
semop(11862378, 0x7fbfffec50, 1) = 0
semop(11862378, 0x7fbfffec60, 1) = 0
semop(11862378, 0x7fbfffec30, 1) = 0
semop(11862378, 0x7fbfffec40, 1) = 0
semop(11862378, 0x7fbfffec50, 1) = 0
semop(11862378, 0x7fbfffec60, 1) = 0
semop(11862378, 0x7fbfffec30, 1) = 0
semop(11862378, 0x7fbfffec40, 1) = 0
semop(11862378, 0x7fbfffec50, 1) = 0
semop(11862378, 0x7fbfffec60, 1) = 0
semop(11862378, 0x7fbfffec30, 1) = 0
semop(11862378, 0x7fbfffec40, 1) = 0
semop(11862378, 0x7fbfffec50, 1) = 0
semop(11862378, 0x7fbfffec60, 1) = 0
semop(11862378, 0x7fbfffec30, 1) = 0
semop(11862378, 0x7fbfffec40, 1) = 0
semop(11862378, 0x7fbfffec50, 1) = 0
semop(11862378, 0x7fbfffec60, 1) = 0
semop(11862378, 0x7fbfffec30, 1) = 0
semop(11862378, 0x7fbfffec40, 1) = 0
semop(11862378, 0x7fbfffec50, 1) = 0
semop(11862378, 0x7fbfffec60, 1) = 0
semop(11862378, 0x7fbfffec30, 1) = 0
semop(11862378, 0x7fbfffec40, 1) = 0
semop(11862378, 0x7fbfffec50, 1) = 0
semop(11862378, 0x7fbfffec60, 1) = 0
semop(11862378, 0x7fbfffec30, 1) = 0
semop(11862378, 0x7fbfffec40, 1) = 0
semop(11862378, 0x7fbfffec50, 1) = 0
semop(11862378, 0x7fbfffec60, 1) = 0
semop(11862378, 0x7fbfffec30, 1) = 0
semop(11862378, 0x7fbfffec40, 1) = 0
semop(11862378, 0x7fbfffec50, 1) = 0
semop(11862378, 0x7fbfffec60, 1) = 0
semop(11862378, 0x7fbfffec30, 1) = 0
semop(11862378, 0x7fbfffec40, 1) = 0
semop(11862378, 0x7fbfffec50, 1) = 0
semop(11862378, 0x7fbfffec60, 1) = 0
semop(11862378, 0x7fbfffec30, 1) = 0
semop(11862378, 0x7fbfffec40, 1) = 0
semop(11862378, 0x7fbfffec50, 1) = 0
semop(11862378, 0x7fbfffec60, 1) = 0
semop(11862378, 0x7fbfffec30, 1) = 0
semop(11862378, 0x7fbfffec40, 1) = 0
semop(11862378, 0x7fbfffec50, 1) = 0
semop(11862378, 0x7fbfffec60, 1) = 0
semop(11862378, 0x7fbfffec30, 1) = 0
semop(11862378, 0x7fbfffec40, 1) = 0
semop(11862378, 0x7fbfffec50, 1) = 0
semop(11862378, 0x7fbfffec60, 1) = 0
semop(11862378, 0x7fbfffec30, 1) = 0
semop(11862378, 0x7fbfffec40, 1) = 0
semop(11862378, 0x7fbfffec50, 1) = 0
semop(11862378, 0x7fbfffec60, 1) = 0
semop(11862378, 0x7fbfffec30, 1) = 0
semop(11862378, 0x7fbfffec40, 1) = 0
semop(11862378, 0x7fbfffec50, 1) = 0
semop(11862378, 0x7fbfffec60, 1) = 0
semop(11862378, 0x7fbfffec30, 1) = 0
semop(11862378, 0x7fbfffec40, 1) = 0
semop(11862378, 0x7fbfffec50, 1) = 0
semop(11862378, 0x7fbfffec60, 1) = 0
semop(11862378, 0x7fbfffec30, 1) = 0
semop(11862378, 0x7fbfffec40, 1) = 0
semop(11862378, 0x7fbfffec50, 1) = 0
semop(11862378, 0x7fbfffec60, 1) = 0
semop(11862378, 0x7fbfffec30, 1) = 0
semop(11862378, 0x7fbfffec40, 1) = 0
semop(11862378, 0x7fbfffec50, 1) = 0
semop(11862378, 0x7fbfffec60, 1) = 0
semop(11862378, 0x7fbfffec30, 1) = 0
semop(11862378, 0x7fbfffec40, 1) = 0
semop(11862378, 0x7fbfffec50, 1) = 0
semop(11862378, 0x7fbfffec60, 1) = 0
semop(11862378, 0x7fbfffec30, 1) = 0
semop(11862378, 0x7fbfffec40, 1) = 0
semop(11862378, 0x7fbfffec50, 1) = 0
semop(11862378, 0x7fbfffec60, 1) = 0
semop(11862378, 0x7fbfffec30, 1) = 0
semop(11862378, 0x7fbfffec40, 1) = 0
semop(11862378, 0x7fbfffec50, 1) = 0
semop(11862378, 0x7fbfffec60, 1) = 0
semop(11862378, 0x7fbfffec30, 1) = 0
semop(11862378, 0x7fbfffec40, 1) = 0
semop(11862378, 0x7fbfffec50, 1) = 0
semop(11862378, 0x7fbfffec60, 1) = 0
semop(11862378, 0x7fbfffec30, 1) = 0
semop(11862378, 0x7fbfffec40, 1) = 0
semop(11862378, 0x7fbfffec50, 1) = 0
semop(11862378, 0x7fbfffec60, 1) = 0
semop(11862378, 0x7fbfffec30, 1) = 0
semop(11862378, 0x7fbfffec40, 1) = 0
semop(11862378, 0x7fbfffec50, 1) = 0
semop(11862378, 0x7fbfffec60, 1) = 0
semop(11862378, 0x7fbfffec30, 1) = 0
semop(11862378, 0x7fbfffec40, 1) = 0
semop(11862378, 0x7fbfffec50, 1) = 0
semop(11862378, 0x7fbfffec60, 1) = 0
semop(11862378, 0x7fbfffec30, 1) = 0
semop(11862378, 0x7fbfffec40, 1) = 0
semop(11862378, 0x7fbfffec50, 1) = 0
semop(11862378, 0x7fbfffec60, 1) = 0
semop(11862378, 0x7fbfffec30, 1) = 0
semop(11862378, 0x7fbfffec40, 1) = 0
semop(11862378, 0x7fbfffec50, 1) = 0
semop(11862378, 0x7fbfffec60, 1) = 0
semop(11862378, 0x7fbfffec30, 1) = 0
semop(11862378, 0x7fbfffec40, 1) = 0
semop(11862378, 0x7fbfffec50, 1) = 0
semop(11862378, 0x7fbfffec60, 1) = 0
semop(11862378, 0x7fbfffec30, 1) = 0
semop(11862378, 0x7fbfffec40, 1) = 0
semop(11862378, 0x7fbfffec50, 1) = 0
semop(11862378, 0x7fbfffec60, 1) = 0
semop(11862378, 0x7fbfffec30, 1) = 0
semop(11862378, 0x7fbfffec40, 1) = 0
semop(11862378, 0x7fbfffec50, 1) = 0
semop(11862378, 0x7fbfffec60, 1) = 0
semop(11862378, 0x7fbfffec30, 1) = 0
semop(11862378, 0x7fbfffec40, 1) = 0
semop(11862378, 0x7fbfffec50, 1) = 0
semop(11862378, 0x7fbfffec60, 1) = 0
semop(11862378, 0x7fbfffec30, 1) = 0
semop(11862378, 0x7fbfffec40, 1) = 0
semop(11862378, 0x7fbfffec50, 1) = 0
semop(11862378, 0x7fbfffec60, 1) = 0
semop(11862378, 0x7fbfffec30, 1) = 0
semop(11862378, 0x7fbfffec40, 1) = 0
semop(11862378, 0x7fbfffec50, 1) = 0
semop(11862378, 0x7fbfffec60, 1) = 0
semop(11862378, 0x7fbfffec30, 1) = 0
semop(11862378, 0x7fbfffec40, 1) = 0
semop(11862378, 0x7fbfffec50, 1) = 0
semop(11862378, 0x7fbfffec60, 1) = 0
semop(11862378, 0x7fbfffec30, 1) = 0
semop(11862378, 0x7fbfffec40, 1) = 0
semop(11862378, 0x7fbfffec50, 1) = 0
semop(11862378, 0x7fbfffec60, 1) = 0
semop(11862378, 0x7fbfffec30, 1) = 0
semop(11862378, 0x7fbfffec40, 1) = 0
semop(11862378, 0x7fbfffec50, 1) = 0
semop(11862378, 0x7fbfffec60, 1) = 0
semop(11862378, 0x7fbfffec30, 1) = 0
semop(11862378, 0x7fbfffec40, 1) = 0
semop(11862378, 0x7fbfffec50, 1) = 0
semop(11862378, 0x7fbfffec60, 1) = 0
semop(11862378, 0x7fbfffec30, 1) = 0
semop(11862378, 0x7fbfffec40, 1) = 0
semop(11862378, 0x7fbfffec50, 1) = 0
semop(11862378, 0x7fbfffec60, 1) = 0
semop(11862378, 0x7fbfffec30, 1) = 0
semop(11862378, 0x7fbfffec40, 1) = 0
semop(11862378, 0x7fbfffec50, 1) = 0
semop(11862378, 0x7fbfffec60, 1) = 0
semop(11862378, 0x7fbfffec30, 1) = 0
semop(11862378, 0x7fbfffec40, 1) = 0
semop(11862378, 0x7fbfffec50, 1) = 0
semop(11862378, 0x7fbfffec60, 1) = 0
semop(11862378, 0x7fbfffec30, 1) = 0
semop(11862378, 0x7fbfffec40, 1) = 0
semop(11862378, 0x7fbfffec50, 1) = 0
semop(11862378, 0x7fbfffec60, 1) = 0
semop(11862378, 0x7fbfffec30, 1) = 0
semop(11862378, 0x7fbfffec40, 1) = 0
semop(11862378, 0x7fbfffec50, 1) = 0
semop(11862378, 0x7fbfffec60, 1) = 0
semop(11862378, 0x7fbfffec30, 1) = 0
semop(11862378, 0x7fbfffec40, 1) = 0
semop(11862378, 0x7fbfffec50, 1) = 0
semop(11862378, 0x7fbfffec60, 1) = 0
semop(11862378, 0x7fbfffec30, 1) = 0
semop(11862378, 0x7fbfffec40, 1) = 0
semop(11862378, 0x7fbfffec50, 1) = 0
semop(11862378, 0x7fbfffec60, 1) = 0
semop(11862378, 0x7fbfffec30, 1) = 0
semop(11862378, 0x7fbfffec40, 1) = 0
semop(11862378, 0x7fbfffec50, 1) = 0
semop(11862378, 0x7fbfffec60, 1) = 0
semop(11862378, 0x7fbfffec30, 1) = 0
semop(11862378, 0x7fbfffec40, 1) = 0
semop(11862378, 0x7fbfffec50, 1) = 0
semop(11862378, 0x7fbfffec60, 1) = 0
semop(11862378, 0x7fbfffec30, 1) = 0
semop(11862378, 0x7fbfffec40, 1) = 0
semop(11862378, 0x7fbfffec50, 1) = 0
semop(11862378, 0x7fbfffec60, 1) = 0
semop(11862378, 0x7fbfffec30, 1) = 0
semop(11862378, 0x7fbfffec40, 1) = 0
semop(11862378, 0x7fbfffec50, 1) = 0
semop(11862378, 0x7fbfffec60, 1) = 0
semop(11862378, 0x7fbfffec30, 1) = 0
semop(11862378, 0x7fbfffec40, 1) = 0
semop(11862378, 0x7fbfffec50, 1) = 0
semop(11862378, 0x7fbfffec60, 1) = 0
semop(11862378, 0x7fbfffec30, 1) = 0
semop(11862378, 0x7fbfffec40, 1) = 0
semop(11862378, 0x7fbfffec50, 1) = 0
semop(11862378, 0x7fbfffec60, 1) = 0
semop(11862378, 0x7fbfffec30, 1) = 0
semop(11862378, 0x7fbfffec40, 1) = 0
semop(11862378, 0x7fbfffec50, 1) = 0
semop(11862378, 0x7fbfffec60, 1) = 0
semop(11862378, 0x7fbfffec30, 1) = 0
semop(11862378, 0x7fbfffec40, 1) = 0
semop(11862378, 0x7fbfffec50, 1) = 0
semop(11862378, 0x7fbfffec60, 1) = 0
semop(11862378, 0x7fbfffec30, 1) = 0
semop(11862378, 0x7fbfffec40, 1) = 0
semop(11862378, 0x7fbfffec50, 1) = 0
semop(11862378, 0x7fbfffec60, 1) = 0
semop(11862378, 0x7fbfffec30, 1) = 0
semop(11862378, 0x7fbfffec40, 1) = 0
semop(11862378, 0x7fbfffec50, 1) = 0
semop(11862378, 0x7fbfffec60, 1) = 0
semop(11862378, 0x7fbfffec30, 1) = 0
semop(11862378, 0x7fbfffec40, 1) = 0
semop(11862378, 0x7fbfffec50, 1) = 0
semop(11862378, 0x7fbfffec60, 1) = 0
semop(11862378, 0x7fbfffec30, 1) = 0
semop(11862378, 0x7fbfffec40, 1) = 0
semop(11862378, 0x7fbfffec50, 1) = 0
semop(11862378, 0x7fbfffec60, 1) = 0
semop(11862378, 0x7fbfffec30, 1) = 0
semop(11862378, 0x7fbfffec40, 1) = 0
semop(11862378, 0x7fbfffec50, 1) = 0
semop(11862378, 0x7fbfffec60, 1) = 0
semop(11862378, 0x7fbfffec30, 1) = 0
semop(11862378, 0x7fbfffec40, 1) = 0
semop(11862378, 0x7fbfffec50, 1) = 0
semop(11862378, 0x7fbfffec60, 1) = 0
semop(11862378, 0x7fbfffec30, 1) = 0
semop(11862378, 0x7fbfffec40, 1) = 0
semop(11862378, 0x7fbfffec50, 1) = 0
semop(11862378, 0x7fbfffec60, 1) = 0
semop(11862378, 0x7fbfffec30, 1) = 0
semop(11862378, 0x7fbfffec40, 1) = 0
semop(11862378, 0x7fbfffec50, 1) = 0
semop(11862378, 0x7fbfffec60, 1) = 0
semop(11862378, 0x7fbfffec30, 1) = 0
semop(11862378, 0x7fbfffec40, 1) = 0
semop(11862378, 0x7fbfffec50, 1) = 0
semop(11862378, 0x7fbfffec60, 1) = 0
semop(11862378, 0x7fbfffec30, 1) = 0
semop(11862378, 0x7fbfffec40, 1) = 0
semop(11862378, 0x7fbfffec50, 1) = 0
semop(11862378, 0x7fbfffec60, 1) = 0
semop(11862378, 0x7fbfffec30, 1) = 0
semop(11862378, 0x7fbfffec40, 1) = 0
semop(11862378, 0x7fbfffec50, 1) = 0
semop(11862378, 0x7fbfffec60, 1) = 0
semop(11862378, 0x7fbfffec30, 1) = 0
semop(11862378, 0x7fbfffec40, 1) = 0
semop(11862378, 0x7fbfffec50, 1) = 0
semop(11862378, 0x7fbfffec60, 1) = 0
semop(11862378, 0x7fbfffec30, 1) = 0
semop(11862378, 0x7fbfffec40, 1) = 0
semop(11862378, 0x7fbfffec50, 1) = 0
semop(11862378, 0x7fbfffec60, 1) = 0
semop(11862378, 0x7fbfffec30, 1) = 0
semop(11862378, 0x7fbfffec40, 1) = 0
semop(11862378, 0x7fbfffec50, 1) = 0
semop(11862378, 0x7fbfffec60, 1) = 0
semop(11862378, 0x7fbfffec30, 1) = 0
semop(11862378, 0x7fbfffec40, 1) = 0
semop(11862378, 0x7fbfffec50, 1) = 0
semop(11862378, 0x7fbfffec60, 1) = 0
semop(11862378, 0x7fbfffec30, 1) = 0
semop(11862378, 0x7fbfffec40, 1) = 0
semop(11862378, 0x7fbfffec50, 1) = 0
semop(11862378, 0x7fbfffec60, 1) = 0
semop(11862378, 0x7fbfffec30, 1) = 0
semop(11862378, 0x7fbfffec40, 1) = 0
semop(11862378, 0x7fbfffec50, 1) = 0
semop(11862378, 0x7fbfffec60, 1) = 0
semop(11862378, 0x7fbfffec30, 1) = 0
semop(11862378, 0x7fbfffec40, 1) = 0
semop(11862378, 0x7fbfffec50, 1) = 0
semop(11862378, 0x7fbfffec60, 1) = 0
semop(11862378, 0x7fbfffec30, 1) = 0
semop(11862378, 0x7fbfffec40, 1) = 0
semop(11862378, 0x7fbfffec50, 1) = 0
semop(11862378, 0x7fbfffec60, 1) = 0
semop(11862378, 0x7fbfffec30, 1) = 0
semop(11862378, 0x7fbfffec40, 1) = 0
semop(11862378, 0x7fbfffec50, 1) = 0
semop(11862378, 0x7fbfffec60, 1) = 0
semop(11862378, 0x7fbfffec30, 1) = 0
semop(11862378, 0x7fbfffec40, 1) = 0
semop(11862378, 0x7fbfffec50, 1) = 0
semop(11862378, 0x7fbfffec60, 1) = 0
semop(11862378, 0x7fbfffec30, 1) = 0
semop(11862378, 0x7fbfffec40, 1) = 0
semop(11862378, 0x7fbfffec50, 1) = 0
semop(11862378, 0x7fbfffec60, 1) = 0
semop(11862378, 0x7fbfffec30, 1) = 0
semop(11862378, 0x7fbfffec40, 1) = 0
semop(11862378, 0x7fbfffec50, 1) = 0
semop(11862378, 0x7fbfffec60, 1) = 0
semop(11862378, 0x7fbfffec30, 1) = 0
semop(11862378, 0x7fbfffec40, 1) = 0
semop(11862378, 0x7fbfffec50, 1) = 0
semop(11862378, 0x7fbfffec60, 1) = 0
semop(11862378, 0x7fbfffec30, 1) = 0
semop(11862378, 0x7fbfffec40, 1) = 0
semop(11862378, 0x7fbfffec50, 1) = 0
semop(11862378, 0x7fbfffec60, 1) = 0
semop(11862378, 0x7fbfffec30, 1) = 0
semop(11862378, 0x7fbfffec40, 1) = 0
semop(11862378, 0x7fbfffec50, 1) = 0
semop(11862378, 0x7fbfffec60, 1) = 0
semop(11862378, 0x7fbfffec30, 1) = 0
semop(11862378, 0x7fbfffec40, 1) = 0
semop(11862378, 0x7fbfffec50, 1) = 0
semop(11862378, 0x7fbfffec60, 1) = 0
semop(11862378, 0x7fbfffec30, 1) = 0
semop(11862378, 0x7fbfffec40, 1) = 0
semop(11862378, 0x7fbfffec50, 1) = 0
semop(11862378, 0x7fbfffec60, 1) = 0
semop(11862378, 0x7fbfffec30, 1) = 0
semop(11862378, 0x7fbfffec40, 1) = 0
semop(11862378, 0x7fbfffec50, 1) = 0
semop(11862378, 0x7fbfffec60, 1) = 0
semop(11862378, 0x7fbfffec30, 1) = 0
semop(11862378, 0x7fbfffec40, 1) = 0
semop(11862378, 0x7fbfffec50, 1) = 0
semop(11862378, 0x7fbfffec60, 1) = 0
semop(11862378, 0x7fbfffec30, 1) = 0
semop(11862378, 0x7fbfffec40, 1) = 0
semop(11862378, 0x7fbfffec50, 1) = 0
semop(11862378, 0x7fbfffec60, 1) = 0
semop(11862378, 0x7fbfffec30, 1) = 0
semop(11862378, 0x7fbfffec40, 1) = 0
semop(11862378, 0x7fbfffec50, 1) = 0
semop(11862378, 0x7fbfffec60, 1) = 0
semop(11862378, 0x7fbfffec30, 1) = 0
semop(11862378, 0x7fbfffec40, 1) = 0
semop(11862378, 0x7fbfffec50, 1) = 0
semop(11862378, 0x7fbfffec60, 1) = 0
semop(11862378, 0x7fbfffec30, 1) = 0
semop(11862378, 0x7fbfffec40, 1) = 0
semop(11862378, 0x7fbfffec50, 1) = 0
semop(11862378, 0x7fbfffec60, 1) = 0
semop(11862378, 0x7fbfffec30, 1) = 0
semop(11862378, 0x7fbfffec40, 1) = 0
semop(11862378, 0x7fbfffec50, 1) = 0
semop(11862378, 0x7fbfffec60, 1) = 0
semop(11862378, 0x7fbfffec30, 1) = 0
semop(11862378, 0x7fbfffec40, 1) = 0
semop(11862378, 0x7fbfffec50, 1) = 0
semop(11862378, 0x7fbfffec60, 1) = 0
semop(11862378, 0x7fbfffec30, 1) = 0
semop(11862378, 0x7fbfffec40, 1) = 0
semop(11862378, 0x7fbfffec50, 1) = 0
semop(11862378, 0x7fbfffec60, 1) = 0
semop(11862378, 0x7fbfffec30, 1) = 0
semop(11862378, 0x7fbfffec40, 1) = 0
semop(11862378, 0x7fbfffec50, 1) = 0
semop(11862378, 0x7fbfffec60, 1) = 0
semop(11862378, 0x7fbfffec30, 1) = 0
semop(11862378, 0x7fbfffec40, 1) = 0
semop(11862378, 0x7fbfffec50, 1) = 0
semop(11862378, 0x7fbfffec60, 1) = 0
semop(11862378, 0x7fbfffec30, 1) = 0
semop(11862378, 0x7fbfffec40, 1) = 0
semop(11862378, 0x7fbfffec50, 1) = 0
semop(11862378, 0x7fbfffec60, 1) = 0
semop(11862378, 0x7fbfffec30, 1) = 0
semop(11862378, 0x7fbfffec40, 1) = 0
semop(11862378, 0x7fbfffec50, 1) = 0
semop(11862378, 0x7fbfffec60, 1) = 0
semop(0, 0x7fbfffebf0, 1) = 0
semop(0, 0x7fbfffec00, 1) = 0
semop(1638450, 0x7fbfffeb80, 1) = 0
semop(1638450, 0x7fbfffeb90, 1) = 0
semop(0, 0x7fbfffebc0, 1) = 0
semop(0, 0x7fbfffebd0, 1) = 0
read(58, "\4\0\0\0\230\211\247\206\v\0\0\0\354\1 \2\0 \0 \300\237"...,
8192) = 8192
semop(0, 0x7fbfffebf0, 1) = 0
semop(0, 0x7fbfffec00, 1) = 0
semop(1638450, 0x7fbfffec00, 1) = 0
semop(1638450, 0x7fbfffec10, 1) = 0
semop(0, 0x7fbfffec10, 1) = 0
semop(0, 0x7fbfffec20, 1) = 0
semop(1638450, 0x7fbfffec30, 1) = 0
semop(1638450, 0x7fbfffec40, 1) = 0
semop(1638450, 0x7fbfffec50, 1) = 0
semop(1638450, 0x7fbfffec60, 1) = 0
semop(0, 0x7fbfffecb0, 1) = 0
semop(0, 0x7fbfffecc0, 1) = 0
semop(0, 0x7fbfffecd0, 1) = 0
semop(0, 0x7fbfffece0, 1) = 0
semop(1638450, 0x7fbfffec30, 1) = 0
semop(1638450, 0x7fbfffec40, 1) = 0
semop(1638450, 0x7fbfffec50, 1) = 0
semop(1638450, 0x7fbfffec60, 1) = 0
semop(1638450, 0x7fbfffec30, 1) = 0
semop(1638450, 0x7fbfffec40, 1) = 0
semop(1638450, 0x7fbfffec50, 1) = 0
semop(1638450, 0x7fbfffec60, 1) = 0
semop(1638450, 0x7fbfffec30, 1) = 0
semop(1638450, 0x7fbfffec40, 1) = 0
semop(1638450, 0x7fbfffec50, 1) = 0

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Brian Maguire 2003-06-09 17:47:56 Feature Suggestion/Index tuning wizard that automatically decide on indexes
Previous Message Josh Berkus 2003-06-09 16:59:45 Re: [GENERAL] MySQL gets $19.5 MM

Browse pgsql-patches by date

  From Date Subject
Next Message Tom Lane 2003-06-10 06:08:30 Re: Thousands of semops for every i/o
Previous Message Bruce Momjian 2003-06-09 14:19:20 Re: Ipv6 network cleanup patch #2.