Received: from localhost (maia-2.hub.org [200.46.204.187])
	by postgresql.org (Postfix) with ESMTP id 71D479FBB42
	for <pgsql-sql-postgresql.org@postgresql.org>;
	Wed, 28 Mar 2007 17:59:30 -0300 (ADT)
Received: from postgresql.org ([200.46.204.71])
	by localhost (mx1.hub.org [200.46.204.187]) (amavisd-maia, port 10024)
	with ESMTP id 59181-02 for <pgsql-sql-postgresql.org@postgresql.org>;
	Wed, 28 Mar 2007 17:59:23 -0300 (ADT)
X-Greylist: domain auto-whitelisted by SQLgrey-1.7.4
Received: from ug-out-1314.google.com (ug-out-1314.google.com [66.249.92.171])
	by postgresql.org (Postfix) with ESMTP id D45749FB965
	for <pgsql-sql@postgresql.org>; Wed, 28 Mar 2007 17:59:25 -0300 (ADT)
Received: by ug-out-1314.google.com with SMTP id k3so308229ugf
	for <pgsql-sql@postgresql.org>; Wed, 28 Mar 2007 13:59:24 -0700 (PDT)
DKIM-Signature: a=rsa-sha1; c=relaxed/relaxed; d=gmail.com; s=beta;
	h=domainkey-signature:received:received:message-id:date:from:to:subject:mime-version:content-type;
	b=VyXuq47QKRmz9900n6XMARHcbYhLybeXWczpbXxerybDvAgQmFyahRtSr8opkZsCJXRYg1WWafms/D0KyDy78uS3WssYNb8J9ROQ+T62asTU8DWmVm0oXtaRNuUY/4ZMGEWrNBeLoQY6u+dSO+uzfJsHo0u9koi8PcxYcH5Lefs=
DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=beta;
	h=received:message-id:date:from:to:subject:mime-version:content-type;
	b=V1PTIye7w6rC97EKswwbFdM2rxi80jyfe6jEgryh60pAk7xW2ntCopLKRg1uGrKpyPKmPH+zPA/rSaJCEnMwcADmf7cG7rhLmyLU0jTvNiS1ZKdiCbIOS7xzScuNU2wjbEWkuHJaOHWSsc33VmvXfunStqUTVERYvDDUX0D+Qzk=
Received: by 10.67.28.4 with SMTP id f4mr870128ugj.1175115564267;
	Wed, 28 Mar 2007 13:59:24 -0700 (PDT)
Received: by 10.66.247.18 with HTTP; Wed, 28 Mar 2007 13:59:24 -0700 (PDT)
Message-ID: <7539aebb0703281359v5b56cc59xf9e80ad4a74e51d7@mail.gmail.com>
Date: Wed, 28 Mar 2007 16:59:24 -0400
From: Sumeet <asumeet@gmail.com>
To: pgsql-sql <pgsql-sql@postgresql.org>
Subject: Track query status
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="----=_Part_4415_21130235.1175115564232"
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Archive-Number: 200703/339
X-Sequence-Number: 27977

------=_Part_4415_21130235.1175115564232
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

Hi all,

I have ran a update query on a dataset which has about 48 million records
and the query is already running for the third day....im so tempted to the
kill this query now....is there a way to know if the query is running??
here is the query i've ran

UPDATE ma SET av=to_tsvector('default',coalesce(name_first,'') ||' '||
coalesce(name_last,''));


Thanks,
Sumeet

------=_Part_4415_21130235.1175115564232
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

Hi all,<br><br>I have ran a update query on a dataset which has about 48 million records and the query is already running for the third day....im so tempted to the kill this query now....is there a way to know if the query is running??
<br>here is the query i&#39;ve ran<br><br>UPDATE ma SET av=to_tsvector(&#39;default&#39;,coalesce(name_first,&#39;&#39;) ||&#39; &#39;|| coalesce(name_last,&#39;&#39;));<br clear="all"><br><br>Thanks,<br>Sumeet

------=_Part_4415_21130235.1175115564232--