From: Rodrigo Moreno <rodrigo.miguel@terra.com.br>
To: 'Tom Lane' <tgl@sss.pgh.pa.us>
Cc: pgsql-performance@postgresql.org
Subject: RES: RES: How to improve postgres performace
Date: Mon, 18 Apr 2005 14:46:56 -0300
Message-ID: <20050418174701.BDD1219007F@arica.terra.com.br> (raw)
In-Reply-To: <23919.1113845568@sss.pgh.pa.us>
> That max_fsm_pages value is enough to cover 8Gb, so it should work OK for
a database disk footprint up to 10 or so Gb. > I don't know how many tables
in your installation so I can't say if max_fsm_relations is high enough, but
you can check >that by looking at the tail end of the output of VACUUM
VERBOSE. (Or just count 'em ;-))
The last count in vacuum verbose shows me 92 relations, and I know the lower
value for max_fsm_relations is enough, maybe I'll change to 500.
> Offhand these look reasonable, though, so if you are seeing database bloat
over time it probably means you need to tweak > your autovacuum settings.
I'm not much of an autovacuum expert, but maybe someone else can help you
there.
I'll let the autovacuum running this week to see what happen.
> You might want to keep track of physical file sizes over a period of time
and try to determine exactly where the bloat > is happening.
There is two mostly used and bigger tables, I'll keep eyes on both tables.
Thanks
Rodrigo Moreno
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-performance@postgresql.org
Cc: rodrigo.miguel@terra.com.br, tgl@sss.pgh.pa.us
Subject: Re: RES: RES: How to improve postgres performace
In-Reply-To: <20050418174701.BDD1219007F@arica.terra.com.br>
* 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