Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
Re: Lock contention during inserts
- From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
- To: carlosreimer(at)terra(dot)com(dot)br
- Cc: pgsql-general(at)postgresql(dot)org
- Subject: Re: Lock contention during inserts
- Date: Tue, 20 Jun 2006 22:42:59 -0400
- Message-id: <5691(dot)1150857779(at)sss(dot)pgh(dot)pa(dot)us>
"Carlos H. Reimer" <carlosreimer(at)terra(dot)com(dot)br> writes: > During mass inserts, we have some locking contention in tables referenced by > foreign keys. It´s a 8.0.3 box > and I know that 8.1 solved this but I would like to know if there is an easy > and safe way to only apply this patch to 8.0.3? If it were a simple fix it would have been fixed many versions ago. Update to 8.1. regards, tom lane
- References:
- Lock contention during inserts
- From: Carlos H. Reimer
- Lock contention during inserts
- Prev by Date: Lock contention during inserts
- Next by Date: multiple statement 'instead of' rule
- Previous by thread: Lock contention during inserts
- Next by thread: multiple statement 'instead of' rule
- Indexes: