<Atul.Goel@xxxxxxxxxxxxxxxxxxx> writes: > I by mistake ran a query to update a huge table with around 500000 rows and has to kill the session. > I found the process-id from the query select * from pg_stat_activity. I killed the process using Kill -9 process_id. > This caused all other sessions in the system to be killed and database was unreachable for a minute or so. > MY QUESTION: Is this normal? Yes. That is not the recommended way to cancel a query. regards, tom lane -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
