On Thu, Jun 11, 2009 at 8:49 AM, "Stéphane A.
Schildknecht"<stephane.schildknecht at postgresqlfr.org> wrote:
> One of the table I have in a set of replication (123 tables or such) contains
> some 6 000 000 rows. Let's call it mybigtable (MBT).
>
> I need to update more than 300 000 rows at once in MBT.
>
> I wonder what the best option is.
>

6 million rows is not "big". ;-)

We regularly do updates this big to our bigger tables (200 million row
range).  Slony handles it just fine.  Sometimes the replication lags
for a couple of minutes, but it always catches up.

It all depends on whether your hardware is capable of handling the
load you throw at it.