On Sat, 2012-07-07 at 10:45 -0500, Michael Shapiro wrote: > Is it possible to run an update in the background? I have an update to 23+ > million records that will very likely take a few hours. > Is it possible to issue the update in PgAdmin, and then exit PgAdmin and > have the update continue on the server?
No, that's not possible. As soon as you quit pgadmin, the connection is dropped, and your statement is rollbacked.
