Re: Table UPDATE is too slow

Поиск
Список
Период
Сортировка
От Kevin Barnard
Тема Re: Table UPDATE is too slow
Дата
Msg-id b068057c040905181998476d1@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Table UPDATE is too slow  ("Marinos J. Yannikos" <mjy@geizhals.at>)
Ответы The usual sequential scan, but with LIMIT !  (Pierre-Frédéric Caillaud<lists@boutiquenumerique.com>)
Список pgsql-performance
Do all of the commands to swap tables in a transaction.  The table
gets locked briefly but should have a lot less impact then the update
command.


On Mon, 06 Sep 2004 01:28:04 +0200, Marinos J. Yannikos <mjy@geizhals.at> wrote:
>
> That said, I'm not entirely sure how well postgres' client libraries can
> deal with tables being renamed while in use, perhaps someone can shed
> some light on this.
>

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

Предыдущее
От: "Marinos J. Yannikos"
Дата:
Сообщение: Re: Table UPDATE is too slow
Следующее
От: Martin Foster
Дата:
Сообщение: Tanking a server with shared memory