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.
But if it is a text file with multiple INSERTs just by themselves, I'd guess killing
the postmaster would live you with a table only half-full.
cheers,
thalis
On Fri, 8 Jun 2001, Thalis A. Kalfigopoulos wrote:
> 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 that query from the client or admin
> > side?
> >
> >
> > -Thanks
> >
> > ---------------------------(end of broadcast)---------------------------
> > TIP 4: Don't 'kill -9' the postmaster
> >
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to [EMAIL PROTECTED] so that your
> message can get through to the mailing list cleanly
>
---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
