Re: New server to improve performance on our large and busy DB - advice?

From: "Carlo Stonebanks" <stonec(dot)register(at)sympatico(dot)ca>
To: pgsql-performance(at)postgresql(dot)org
Subject: Re: New server to improve performance on our large and busy DB - advice?
Date: 2010-01-19 21:09:56
Message-ID: hj572o$pgg$1@news.hub.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Hi Scott,

Sorry for the very late reply on this post, but I'd like to follow up. The
reason that I took so long to reply was due to this suggestion:

<<Run vacuum verbose to see if you're
overrunning the max_fsm_pages settings or the max_fsm_relations.
>>

My first thought was, does he mean against the entire DB? That would take a
week! But, since it was recommended, I decided to see what would happen. So,
I just ran VACUUM VERBOSE. After five days, it was still vacuuming and the
server admin said they needed to bounce the server, which means the command
never completed (I kept the log of the progress so far, but don't know if
the values you needed would appear at the end. I confess I have no idea how
to relate the INFO and DETAIL data coming back with regards to max_fsm_pages
settings or the max_fsm_relations.

So, now my questions are:

1) Did you really mean you wanted VACUUM VERBOSE to run against the entire
DB?
2) Given my previous comments on the size of the DB (and my thinking that
this is an exceptionally large and busy DB) were you expecting it to take
this long?
3) I took no exceptional measures before running it, I didn't stop the
automated import processes, I didn't turn off autovacuum. Would this have
accounted for the time it is taking to THAT degree?
4) Any other way to get max_fsm_pages settings and max_fsm_relations?

Carlo

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Jeff Davis 2010-01-19 22:38:03 Re: performance question on VACUUM FULL (Postgres 8.4.2)
Previous Message Scott Carey 2010-01-19 20:31:04 Re: Inserting 8MB bytea: just 25% of disk perf used?