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.

--
 Craig Ringer                   http://www.2ndQuadrant.com/
 PostgreSQL Development, 24x7 Support, Training & Services

В списке pgsql-hackers по дате отправления:

Предыдущее
От: Ildus Kurbangaliev
Дата:
Сообщение: Re: [PATCH] Refactoring of LWLock tranches
Следующее
От: Peter Eisentraut
Дата:
Сообщение: Re: proposal: numeric scale functions