Re: Table UPDATE is too slow - Mailing list pgsql-performance

From Kevin Barnard
Subject Re: Table UPDATE is too slow
Date
Msg-id b068057c040905181998476d1@mail.gmail.com
Whole thread Raw
In response to Re: Table UPDATE is too slow  ("Marinos J. Yannikos" <mjy@geizhals.at>)
Responses The usual sequential scan, but with LIMIT !  (Pierre-Frédéric Caillaud<lists@boutiquenumerique.com>)
List 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 by date:

Previous
From: "Marinos J. Yannikos"
Date:
Subject: Re: Table UPDATE is too slow
Next
From: Martin Foster
Date:
Subject: Tanking a server with shared memory