Re: can we add SKIP LOCKED to UPDATE?
| От | Craig Ringer |
|---|---|
| Тема | Re: can we add SKIP LOCKED to UPDATE? |
| Дата | |
| Msg-id | CAMsr+YG5xfi6h-P6HRMw1+bMO0_eXAbaJGmAKf4ze-cOHwzpEg@mail.gmail.com обсуждение исходный текст |
| Ответ на | Re: can we add SKIP LOCKED to UPDATE? (Torsten Zühlsdorff <mailinglists@toco-domains.de>) |
| Ответы |
Re: can we add SKIP LOCKED to UPDATE?
|
| Список | pgsql-hackers |
On 11 November 2015 at 16:02, Torsten Zühlsdorff <mailinglists@toco-domains.de> wrote:
>From my experience most databases are just tpo small. Their operations finish before there can be a deadlock. Same for race conditions - most developer don't know about them, because they never stumbled upon them. I am matching regularly discussions if a database is already to big when holding 10.000 records in the whole cluster...
Ha. Yes. So true.
I see Stack Overflow posts where somebody explains that their query takes ages on their Huge!!1! database. Then it turns out the query takes 0.2 seconds on a 400MB table.
Huge. Right.
В списке pgsql-hackers по дате отправления: