Postgres Pro
Downloads
Home   >   mailing lists

Re: how to cancel a query in progress - Mailing list pgsql-general

From Tom Lane
Subject Re: how to cancel a query in progress
Date
Msg-id 28641.1245254998@sss.pgh.pa.us
Whole thread Raw
In response to Re: how to cancel a query in progress  (Whit Armstrong <armstrong.whit@gmail.com>)
Responses Re: how to cancel a query in progress
List pgsql-general
Tree view 
Whit Armstrong <armstrong.whit@gmail.com> writes:
> Are there any integrity checks I need to run on the db after this type
> of crash and recovery, or is vacuum --all good enough?

There isn't anything you need to do.  Postgres crashes don't corrupt
on-disk data, as a general rule, and a SIGKILL crash seems particularly
safe from that.

            regards, tom lane

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Playing with set returning functions in SELECT list - behaviour intended?
Next
From: Steve Atkins
Date:
Subject: Re: used for large media files