Horton

Re: How to determine a database is intact?

Wes <wespvp@syntegra.com>

View thread View on postgr.es
From: Wes <wespvp@syntegra.com>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: Jan Wieck <JanWieck@yahoo.com>, Richard Huxton <dev@archonet.com>, Postgres General <pgsql-general@postgresql.org>
Date: 2004-09-08T22:47:47Z
Lists: pgsql-general 
On 9/8/04 9:11 AM, "Tom Lane" <tgl@sss.pgh.pa.us> wrote:

> FWIW, increasing sort_mem for the reload process would probably help
> with the index and FK rebuilds.  (8.0 rejiggers things so that the
> memory constraints for these operations are driven off a separate
> variable, but in 7.* you need to muck about with sort_mem.  The
> appropriate value for one-off operations is a lot higher than what
> you would want multiple competing backends to be using.)

How big are we talking?  I've got it set to 65535 right now.  Multiply it by
10?

Wes