Quick Links

creating trigger in 8.3 -- very slow

From:	Greg Williamson <gwilliamson39(at)yahoo(dot)com>
To:	"pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org>
Subject:	creating trigger in 8.3 -- very slow
Date:	2012-08-23 01:16:18
Message-ID:	1345684578.14923.YahooMailNeo@web125904.mail.ne1.yahoo.com
Views:	Raw Message \| Whole Thread \| Download mbox \| Resend email
Thread:
Lists:	pgsql-admin

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 -- it is just hanging.

Can this be done in 8.3 ? Will it eventually complete ?

Thanks for any advice, information, etc.!

Greg Williamson

Responses

Re: creating trigger in 8.3 -- very slow at 2012-08-23 01:45:06 from Tom Lane

Browse pgsql-admin by date

	From	Date	Subject
Next Message	Tom Lane	2012-08-23 01:45:06	Re: creating trigger in 8.3 -- very slow
Previous Message	Kevin Grittner	2012-08-20 16:08:44	Re: When I executed type cast functions. The postgres normal concatenation operator query was breaking.