This is a discussion on Lock contention during inserts within the Pgsql General forums, part of the PostgreSQL category; --> Hello, During mass inserts, we have some locking contention in tables referenced by foreign keys. Itīs a 8.0.3 box ...
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
| ||||
| Hello, 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? Reimer ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings |
| ||||
| "Carlos H. Reimer" <carlosreimer@terra.com.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 ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster |