Dennis <[EMAIL PROTECTED]> writes:
> Is there a way to cleanly shut down that query from the client or admin
> side?
>From the client: send a query-cancel request (for example, typing ^C
in psql usually does this).
>From the admin: send a SIGINT to the backend running the query, which
has the s
To be more precise, if by "a very large insert" you mean an import of a large data
file via COPY, then it is fully transactional i.e. if you kill -TERM the corresponding
postmaster, it'll be like the insert never took place.
If you mean multiple INSERTs in a transaction block then again the same
You can kill -TERM the postmaster that is executing the particular query.
cheers,
t.
On Fri, 8 Jun 2001, Dennis wrote:
> If I have a database running, and I see that
> there is a postmaster process taking 99.9% cpu.
>
> ie, a very large insert query.
>
> Is there a way to cleanly shut down
