pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedcreating trigger in 8.3 -- very slow
2+ messages / 2 participants
[nested] [flat]
* creating trigger in 8.3 -- very slow
@ 2012-08-23 01:16 Greg Williamson <gwilliamson39@yahoo.com>
0 siblings, 1 reply; 2+ messages in thread
From: Greg Williamson @ 2012-08-23 01:16 UTC (permalink / raw)
To: 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
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: creating trigger in 8.3 -- very slow
@ 2012-08-23 01:45 Tom Lane <tgl@sss.pgh.pa.us>
parent: Greg Williamson <gwilliamson39@yahoo.com>
0 siblings, 0 replies; 2+ messages in thread
From: Tom Lane @ 2012-08-23 01:45 UTC (permalink / raw)
To: Greg Williamson <gwilliamson39@yahoo.com>; +Cc: pgsql-admin
Greg Williamson <gwilliamson39@yahoo.com> writes:
> 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.
CREATE TRIGGER per se is pretty quick ... but it requires an exclusive
lock on the table. Most likely your problem is that it's backed up
behind existing holders of locks. The pg_locks view should help you
figure out what's blocking it.
regards, tom lane
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2012-08-23 01:45 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2012-08-23 01:16 creating trigger in 8.3 -- very slow Greg Williamson <gwilliamson39@yahoo.com>
2012-08-23 01:45 ` Tom Lane <tgl@sss.pgh.pa.us>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox