Обсуждение: background process?
Is it possible to run an update in the background? I have an update to 23+ million records that will very likely take a fewhours.<br />Is it possible to issue the update in PgAdmin, and then exit PgAdmin and have the update continue on the server?<br/><br /><br />
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. -- Guillaume http://blog.guillaume.lelarge.info http://www.dalibo.com
Thanks. That's what I had thought, but I just wanted to make sure.
I'll use psql (or write a perl script).
I'll use psql (or write a perl script).
On Sat, Jul 7, 2012 at 11:24 AM, Guillaume Lelarge <guillaume@lelarge.info> wrote:
No, that's not possible. As soon as you quit pgadmin, the connection is dropped, and your statement is rollbacked.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?
--
Guillaume
http://blog.guillaume.lelarge.info
http://www.dalibo.com