Re: pg_restore: error returned by PQputline - Mailing list pgsql-general

From Clodoaldo Pinto Neto
Subject Re: pg_restore: error returned by PQputline
Date
Msg-id 20040830102735.8468.qmail@web40904.mail.yahoo.com
Whole thread Raw
In response to Re: pg_restore: error returned by PQputline  (Richard Huxton <dev@archonet.com>)
List pgsql-general
 --- Richard Huxton <dev@archonet.com> escreveu:
> The sort_mem might be too high at 64MB - that's memory per sort and I
>
> don't know how many simultaneous sorts you might have.
> --
Lowered it to 32MB and restarted the server with the same bad result.

How many simultaneous sorts a restore can do? Will it build more than
one index at a time? I know nothing about dumping and restoring or
database internals. Just following the recipe.

Regards,
Clodoaldo Pinto





_______________________________________________________
Yahoo! Acesso Grátis - navegue de graça com conexão de qualidade!
http://br.acesso.yahoo.com/

pgsql-general by date:

Previous
From: Francois Suter
Date:
Subject: Technical recommendations
Next
From: Clodoaldo Pinto Neto
Date:
Subject: Re: pg_restore: error returned by PQputline