From: Scott Marlowe <scott.marlowe@gmail.com>
To: Carol Walter <walterc@indiana.edu>
Cc: pgsql-admin@postgresql.org
Subject: Re: Performance tuning...
Date: Wed, 2 Jan 2008 10:02:09 -0600
Message-ID: <dcc563d10801020802h4870c409pe70d57a6d5338754@mail.gmail.com> (raw)
In-Reply-To: <3D51BC79-C289-4B35-B1B1-078F82D00A1A@indiana.edu>
References: <3D51BC79-C289-4B35-B1B1-078F82D00A1A@indiana.edu>
On Jan 2, 2008 9:34 AM, Carol Walter <walterc@indiana.edu> wrote:
> Greetings and Salutations...
>
> This has probably been discussed a number of times, but I really need
> your help. I am upgrading from 8.1 to 8.2. Right now I have the
> restore of the database to the new version running. It has been
> running since December 21, at 4:30 PM. I'm in a University
> environment and we're in the midst of winter break, so there is very
> little processing going on on my systems. This is actually a test
> run of the upgrade. I thought I would be able to do the test and
> live during the break but as slow as this thing is going, I may be
> lucky just to finish the test. This brings me to my question. Is
> there any performance tuning I can do to make this think run faster?
> This is a Sun box running Solaris 10.
That's a VERY long time for a restore to be running. You might want
to look at using pgbulkloader on your data if that helps.
Hard to say what's going wrong with this overview of info.
How big is the database on disk?
How big is the backup?
Where is the backup spending most of its time? restoring tables or
creating indexes or what?
What are you running out of? CPU, I/O, etc... vmstat iostat and top
can help figure that out.
What kind of disk subsystem do you have?
How many CPUs and how much memory does this machine have?
You can turn off fsync during the restore (good idea to turn it back
on when you're done though)
Turn up maintenance_work_mem to something in the 512M to 1G range
(depending on how much memory your machine has)
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-admin@postgresql.org
Cc: scott.marlowe@gmail.com, walterc@indiana.edu
Subject: Re: Performance tuning...
In-Reply-To: <dcc563d10801020802h4870c409pe70d57a6d5338754@mail.gmail.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