From: | Gavin Love <gavin(at)aardvarkmedia(dot)co(dot)uk> |
---|---|
To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Cc: | Csaba Nagy <nagy(at)ecircle-ag(dot)com>, Postgres general mailing list <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Deadlock Problem |
Date: | 2005-06-15 14:45:55 |
Message-ID: | 42B03F23.3030402@aardvarkmedia.co.uk |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
> If the deadlocks occur because different transactions actually try to
> update the same rows concurrently, then this is an appropriate solution.
>
> However I wonder if Gavin is getting bitten by foreign key deadlocks.
> Is there any foreign key reference from the stats table to other tables?
Tom,
There are no foreign key references to or from this table as the updates
to it consume a large % of the overall DB activity so I kept everything
to a minimum.
I think Csaba has spotted the real problem but given that changing the
order is not that easy and these stats are not mission critical I may
just live with the odd deadlock. At least I understand why this is
happening now.
Thanks,
Gavin
From | Date | Subject | |
---|---|---|---|
Next Message | Steve Atkins | 2005-06-15 15:02:42 | Re: Reporting tools |
Previous Message | Moises Alberto Lindo Gutarra | 2005-06-15 14:31:43 | Re: Reporting tools |