Re: How to determine a database is intact?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Wes <wespvp(at)syntegra(dot)com>
Cc: Jan Wieck <JanWieck(at)yahoo(dot)com>, Richard Huxton <dev(at)archonet(dot)com>, Postgres General <pgsql-general(at)postgresql(dot)org>
Subject: Re: How to determine a database is intact?
Date: 2004-09-08 22:51:57
Message-ID: 24822.1094683917@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Wes <wespvp(at)syntegra(dot)com> writes:
> On 9/8/04 9:11 AM, "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
>> FWIW, increasing sort_mem for the reload process would probably help
>> with the index and FK rebuilds.

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

How much RAM have you got in the machine? I'd think that you could
afford to put, say, a quarter or so of physical RAM into sort_mem, if
there is nothing much else going on during the data import. 64MB is
not a lot on that scale.

regards, tom lane

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Wes Palmer 2004-09-08 23:08:37 Re: How to determine a database is intact?
Previous Message Wes 2004-09-08 22:47:47 Re: How to determine a database is intact?