DROP hangup...

Started by Denis Perchineabout 25 years ago1 messages
#1Denis Perchine
dyp@perchine.com

Hello,

My previous mail about VACUUM deadlock was silently ignored...
Now I have much more interesting trouble...

Just a minutes ago I found out that my usual routine which recreate indices
is hanged... I see the picture like this:

10907 ? SW 0:01 /home/postgres/bin/postgres 127.0.0.1
webmailstation webmailstation DROP waiting

And lots of other backends are also have waiting...

The system is quite heavily loaded. I have > 200.000 queries per day.
There are lot's of inserts and updates, mostly updates.

PostgreSQL 7.0.3pre.
Linux 2.2.16

Any comments? Ideas?

--
Sincerely Yours,
Denis Perchine

----------------------------------
E-Mail: dyp@perchine.com
HomePage: http://www.perchine.com/dyp/
FidoNet: 2:5000/120.5
----------------------------------