Re: pg_upgrade bug found! - Mailing list pgsql-hackers

From Tom Lane
Subject Re: pg_upgrade bug found!
Date
Msg-id 18316.1302297105@sss.pgh.pa.us
Whole thread Raw
In response to Re: pg_upgrade bug found!  (Josh Berkus <josh@agliodbs.com>)
Responses Re: pg_upgrade bug found!  (Bruce Momjian <bruce@momjian.us>)
List pgsql-hackers
Josh Berkus <josh@agliodbs.com> writes:
>> -- It will not lock any tables but will generate I/O.

> add:
> IMPORTANT: Depending on the size and configuration of your database,
> this script may generate a lot of I/O and degrade database performance.
> Users should execute this script during a low traffic period and watch
> the database load.

It might be worth suggesting that people can adjust their vacuum delay
parameters to control the I/O load.
        regards, tom lane


pgsql-hackers by date:

Previous
From: Jeff Janes
Date:
Subject: gincostestimate
Next
From: Robert Haas
Date:
Subject: Re: getting to beta