Re: [PERFORM] 7.3.2 pg_restore very slow

From: Markus Schaber <schabi(at)logix-tt(dot)com>
To: Saranya Sivakumar <sarlavk(at)yahoo(dot)com>
Cc: pgsqlnovice <pgsql-novice(at)postgresql(dot)org>, pgsqlperform <pgsql-performance(at)postgresql(dot)org>
Subject: Re: [PERFORM] 7.3.2 pg_restore very slow
Date: 2006-08-07 18:25:10
Message-ID: 44D78586.8060406@logix-tt.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice pgsql-performance

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

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message Richard Broersma Jr 2006-08-07 19:18:56 Re: [PERFORM] 7.3.2 pg_restore very slow
Previous Message Saranya Sivakumar 2006-08-07 17:28:25 Re: [PERFORM] 7.3.2 pg_restore very slow

Browse pgsql-performance by date

  From Date Subject
Next Message Tom Lane 2006-08-07 18:34:41 Re: High Context-Switches on Linux 8.1.4 Server
Previous Message Scott Marlowe 2006-08-07 18:05:45 Re: Slow transfer speeds