Received: from makus.postgresql.org ([98.129.198.125]) by malur.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1T4M21-00067n-Cy for pgsql-admin@postgresql.org; Thu, 23 Aug 2012 01:16:21 +0000 Received: from nm10-vm2.bullet.mail.ne1.yahoo.com ([98.138.90.158]) by makus.postgresql.org with smtp (Exim 4.72) (envelope-from ) id 1T4M1z-0005FH-Rc for pgsql-admin@postgresql.org; Thu, 23 Aug 2012 01:16:20 +0000 Received: from [98.138.90.50] by nm10.bullet.mail.ne1.yahoo.com with NNFMP; 23 Aug 2012 01:16:19 -0000 Received: from [98.138.89.194] by tm3.bullet.mail.ne1.yahoo.com with NNFMP; 23 Aug 2012 01:16:19 -0000 Received: from [127.0.0.1] by omp1052.mail.ne1.yahoo.com with NNFMP; 23 Aug 2012 01:16:19 -0000 X-Yahoo-Newman-Property: ymail-3 X-Yahoo-Newman-Id: 105888.1469.bm@omp1052.mail.ne1.yahoo.com Received: (qmail 64767 invoked by uid 60001); 23 Aug 2012 01:16:19 -0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.com; s=s1024; t=1345684579; bh=Y5BXTTgKa8g9YU9m9ffjA9SLuLazOrjWXVYDHdyi1dw=; h=X-YMail-OSG:Received:X-Mailer:Message-ID:Date:From:Reply-To:Subject:To:MIME-Version:Content-Type; b=X9w0CohECS0JAxsQJ/kZ5oau/gXs524oN9TwKBGiGtEeujV6pGqY/8ie3kKlsmK6J9dcbq1xytn4XcVRYsQ3sTbSXmI2G9ANDkDPK9n6nbqTuKv/7KG4iX7ArgX7lFMllrESCFsEwoWMNPgCQPKnFSe+Gm3j74SIFS3AH67ApEE= DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; h=X-YMail-OSG:Received:X-Mailer:Message-ID:Date:From:Reply-To:Subject:To:MIME-Version:Content-Type; b=KkCnSeVMjBHadPuWDAQqjNbuF61en3j6MOoc5KlnGUw8E7kizwo+sU1eDP/nT/1nPCe1pXSMvROaRkwm4gqSb7wJb3u70YO+l8GH81cx5kTrED4cUP4GxaNroJOOSU2rJSfhBP3l4MAa+hA5JZLXqeN1WLjCprSn5o8nUrsH3jY=; X-YMail-OSG: 6aBjbAUVM1nV5jd2LwDtSq.yopPLLVTLy.MrkKkDpGJbuKA NcfCJAZerVY50vGLnTF_sYNK_vtJnNWLlCvM0v.bi3kNK394u0H5X7QC4Go8 Tt7RbRmF2bfCdd9Y5xYSexYqClIOqxUb2Omsd6Zl3m6EgSLVS7lbyDrAnTvL aH9CqnNPON7dh7GZI54D816gub0QOAsIa2V6.P0C5BSMLPsqJuBrj0tf.52A AX3v6UyRLD.UTabFM1V4hz1o4ncnKczEHSlWL6.0SrEppzqVW4D1YbdJQk94 og8vSewTo51scccHPU0m9.HaeMQVpn1NksWaIPLfXnLwrhj3c.3Im7or7v3e LhK_l2X7G0cuSxptuQeqqEBYruuLHNx4WoGdBsUudIukBpiRUDIen8GtEo7r FqxqFVtIMpjBSV4OiD2JrmCN7iAcHwfuJM1aUFy0TzSHPIo9QNy2A9Ow- Received: from [199.9.251.45] by web125904.mail.ne1.yahoo.com via HTTP; Wed, 22 Aug 2012 18:16:18 PDT X-Mailer: YahooMailWebService/0.8.121.416 Message-ID: <1345684578.14923.YahooMailNeo@web125904.mail.ne1.yahoo.com> Date: Wed, 22 Aug 2012 18:16:18 -0700 (PDT) From: Greg Williamson Reply-To: Greg Williamson Subject: creating trigger in 8.3 -- very slow To: "pgsql-admin@postgresql.org" MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="897857186-1579324068-1345684578=:14923" X-Pg-Spam-Score: 1.1 (+) X-Archive-Number: 201208/99 X-Sequence-Number: 39920 --897857186-1579324068-1345684578=:14923 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: quoted-printable I've got a fairly large table (186 million rows) that is moderately busy ( = a few inserts per second at most) that I am trying to create a trigger on -= - =A0it is just hanging.=0A=0ACan this be done in 8.3 ? Will it eventually = complete ?=A0=0A=0AThanks for any advice, information, etc.!=0A=0AGreg Will= iamson --897857186-1579324068-1345684578=:14923 Content-Type: text/html; charset=iso-8859-1 Content-Transfer-Encoding: quoted-printable

I've got a fairly large tab= le (186 million rows) that is moderately busy ( a few inserts per second at= most) that I am trying to create a trigger on -- it is just hanging.=

Can this be done in 8.3 ? Will it eventually complete ?&= nbsp;

Thanks for any advice, information, etc.!

G= reg Williamson

--897857186-1579324068-1345684578=:14923--