Hi,

I added an index on a Postgresql 7.4 database this morning (about 50
concurrent users), and then deleted it. I noticed the delete took too
much time to complete, so I logged on the server, and did a "ps -afxu".
I saw a process was stuck in a "drop index waiting" state, and several
others in a "select waiting" state.

I killed the "drop index waiting" process, and all the "select waiting"
processes disappeared. Then I dropped the index again, and it succeeded
this time. 

I never restarted the database server at any time. Is that safe, or is
it a good thing to restart the server in such cases?

Best regards,

Philippe Lang

-- 
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

Reply via email to