Thousands of semops for every i/o

Поиск
Список
Период
Сортировка
От	Jeffrey W. Baker
Тема	Thousands of semops for every i/o
Дата	10 июня 2003 г. 04:52:29
Msg-id	1055179678.5240.18.camel@noodles обсуждение исходный текст
Ответы	Re: Thousands of semops for every i/o (Tom Lane <tgl@sss.pgh.pa.us>)
Список	pgsql-general
Дерево обсуждения
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
В списке pgsql-general по дате отправления:
Предыдущее

От: "Robert Fitzpatrick"
Дата: 10 июня 2003 г., 04:52:20
Сообщение: Pg_dumpall from different versions
Следующее

От:
Дата: 10 июня 2003 г., 04:57:35
Сообщение: Re: Backups and restores.
Вход в личный кабинет

Восстановление пароля

Подтверждение аккаунта

Изменение пароля

Thousands of semops for every i/o

Предыдущее

Следующее
