Re: Kill -9 for a session process caused all the sessions to be killed

<Atul.Goel@globaldatapoint.com> 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