<[email protected]> 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 ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
