Re: Indexes and Tables: Growth and Treatment - Mailing list pgsql-general

From Thomas F.O'Connell
Subject Re: Indexes and Tables: Growth and Treatment
Date
Msg-id 90371CE6-D8D9-11D8-B910-000D93AE0944@sitening.com
Whole thread Raw
In response to Re: Indexes and Tables: Growth and Treatment (Modified by Thomas F. O'Connell)  (Tom Lane <tgl@sss.pgh.pa.us>)
List 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.


pgsql-general by date:

Previous
From: "zuhans@iname.com"
Date:
Subject: more intelligence to pg_dump
Next
From: Bill Moran
Date:
Subject: Re: Can someone please explain this error