From: Richard Broersma Jr <rabroersma@yahoo.com>
To: Saranya Sivakumar <sarlavk@yahoo.com>
To: pgsqlnovice <pgsql-novice@postgresql.org>
To: pgsqlperform <pgsql-performance@postgresql.org>
Subject: Re: [PERFORM] 7.3.2 pg_restore very slow
Date: Mon, 7 Aug 2006 12:18:56 -0700 (PDT)
Message-ID: <20060807191856.43058.qmail@web31801.mail.mud.yahoo.com> (raw)
In-Reply-To: <20060807172825.52230.qmail@web51314.mail.yahoo.com>
> 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.
>
> Is there any work around without changing these parameters to make maximum use of RAM?
>
> We got a new server now with 2GB RAM, but it also has the same value for SHMMAX.
>
> And I am trying the restore with the following conf
> sort_mem = 40960 (changed from 1024)
> shared_buffers = 3000 (changed from 64)
> max_connections = 128 (changed from 32)
This is one of the best links that I can give you in addition to the Postgresql Kernel resource
link.
http://www.powerpostgresql.com/PerfList
I am pretty much a beginner at resource tuning also. In fact, after googling for sources that
describe how to tune kernel parameters, the postgresql documents remains the best documents I've
found so far.
I would be interested if anyone else on the list knows of any resources or books that have an in
depth discussion on methods/strategies to tune kernel parameters to maximized usage of system
resources and at the same time allow for harmonious sharing between various programs/services.
Regards,
Richard Broersma Jr.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: rabroersma@yahoo.com, sarlavk@yahoo.com, pgsql-novice@postgresql.org
Subject: Re: [PERFORM] 7.3.2 pg_restore very slow
In-Reply-To: <20060807191856.43058.qmail@web31801.mail.mud.yahoo.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox