Postgres Pro
Downloads
Home   >   mailing lists

creating trigger in 8.3 -- very slow - Mailing list pgsql-admin

From Greg Williamson
Subject creating trigger in 8.3 -- very slow
Date
Msg-id 1345684578.14923.YahooMailNeo@web125904.mail.ne1.yahoo.com
Whole thread Raw
Responses Re: creating trigger in 8.3 -- very slow  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-admin
Tree view
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


pgsql-admin by date:

Previous
From: "Kevin Grittner"
Date:
Subject: Re: When I executed type cast functions. The postgres normal concatenation operator query was breaking.
Next
From: Tom Lane
Date:
Subject: Re: creating trigger in 8.3 -- very slow