From: Saranya Sivakumar <sarlavk@yahoo.com>
To: Richard Broersma Jr <rabroersma@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 13:07:40 -0700 (PDT)
Message-ID: <20060807200740.93954.qmail@web51315.mail.yahoo.com> (raw)
In-Reply-To: <20060807191856.43058.qmail@web31801.mail.mud.yahoo.com>
Hi All,
Thanks Richard for the additional link. The information is very useful.
The restore completed successfully in 2.5 hours in the new 2GB box, with the same configuration parameters. I think if I can tweak the parameters a little more, I should be able to get it down to the 1 hr down time that we can afford.
Thanks again for all the help.
Sincerely,
Saranya
Richard Broersma Jr <rabroersma@yahoo.com> 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.
>
> 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.
---------------------------------
Want to be your own boss? Learn how on Yahoo! Small Business.
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: sarlavk@yahoo.com, rabroersma@yahoo.com, pgsql-novice@postgresql.org
Subject: Re: [PERFORM] 7.3.2 pg_restore very slow
In-Reply-To: <20060807200740.93954.qmail@web51315.mail.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