| 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: | 00110219392907.31936@dyp.perchine.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
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(at)perchine(dot)com
HomePage: http://www.perchine.com/dyp/
FidoNet: 2:5000/120.5
----------------------------------
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Karel Zak | 2000-11-02 14:38:14 | Re: AW: Re: [GENERAL] Query caching |
| Previous Message | Tom Lane | 2000-11-02 09:14:56 | Re: WAL status update |