Re: [PERFORM] 7.3.2 pg_restore very slow - Mailing list pgsql-novice

From Markus Schaber
Subject Re: [PERFORM] 7.3.2 pg_restore very slow
Date
Msg-id 44D78586.8060406@logix-tt.com
Whole thread Raw
In response to Re: [PERFORM] 7.3.2 pg_restore very slow  (Saranya Sivakumar <sarlavk@yahoo.com>)
List pgsql-novice
Hi, Saranya,

Saranya Sivakumar wrote:
> Thank you very much for the information. The SHMMAX was set to 33554432,
> and that's why it failed to start the postmaster. Thanks for the link to
> the kernel resources article. I guess changing these parameters would
> require recompiling the kernel.

As stated on the
http://www.postgresql.org/docs/8.1/interactive/kernel-resources.html
page, those values can be changed via sysctl or echoing values into
/proc, under linux at least.

HTH,
Markus

--
Markus Schaber | Logical Tracking&Tracing International AG
Dipl. Inf.     | Software Development GIS

Fight against software patents in EU! www.ffii.org www.nosoftwarepatents.org

pgsql-novice by date:

Previous
From: Richard Huxton
Date:
Subject: Re: [PERFORM] 7.3.2 pg_restore very slow
Next
From: "Walid Haider"
Date:
Subject: Unable to connect to PostgreSQL 8 from PGAdmin III