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

DROP hangup...

From: Denis Perchine <dyp(at)perchine(dot)com>
To: pgsql-hackers(at)postgresql(dot)org
Subject: DROP hangup...
Date: 2000-11-02 13:39:29
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-hackers

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 
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(at)perchine(dot)com
FidoNet: 2:5000/120.5

pgsql-hackers by date

Next:From: Karel ZakDate: 2000-11-02 14:38:14
Subject: Re: AW: Re: [GENERAL] Query caching
Previous:From: Tom LaneDate: 2000-11-02 09:14:56
Subject: Re: WAL status update

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