Re: Indexes and Tables: Growth and Treatment

From: Thomas F(dot)O'Connell <tfo(at)sitening(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Indexes and Tables: Growth and Treatment
Date: 2004-07-18 16:43:14
Message-ID: 90371CE6-D8D9-11D8-B910-000D93AE0944@sitening.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Tom,

If I've got the RAM, should I have max_fsm_relations be large enough to
cover _all_ user tables and indexes?

Thanks!

-tfo

On Jul 13, 2004, at 6:58 PM, Tom Lane wrote:

> Try hourly vacuums. If that doesn't stem the tide, make it more often
> (or try autovacuum). Also make sure that your FSM settings are large
> enough; if they're not then no amount of plain vacuuming will keep you
> out of trouble.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message zuhans@iname.com 2004-07-18 16:44:29 more intelligence to pg_dump
Previous Message Thomas F.O'Connell 2004-07-18 16:13:36 Fwd: Indexes and Tables: Growth and Treatment