Re: Large DB, several tuning questions: Index sizes, VACUUM, REINDEX, Autovacuum

From: Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com>
To: Andres Freund <andres(at)anarazel(dot)de>
Cc: Andreas Thiel <andreas(dot)thiel(at)u-blox(dot)com>, pgsql-performance <pgsql-performance(at)postgresql(dot)org>
Subject: Re: Large DB, several tuning questions: Index sizes, VACUUM, REINDEX, Autovacuum
Date: 2009-12-06 20:24:06
Message-ID: dcc563d10912061224t544e5415m388a53277d511259@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

On Sun, Dec 6, 2009 at 12:09 PM, Andres Freund <andres(at)anarazel(dot)de> wrote:
> I know of several instances running with a larger fsm_pages - you could try to
> reduce the fsm_relations setting - I dont know if there are problems lurking
> with such a oversized value.

I run a db with 10M max_fsm_pages and 500k max_fam_relations. We use
about 4.5M pages and only 1200 or so relations. But we HAVE many more
relations than that, in the 40k range, so the higher number for max
relations is to make sure that if all those start getting updated we
can track them too.

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Ben Brehmer 2009-12-07 18:12:28 Load experimentation
Previous Message Andres Freund 2009-12-06 19:09:59 Re: Large DB, several tuning questions: Index sizes, VACUUM, REINDEX, Autovacuum