From: Jim C. Nasby <jnasby@pervasive.com>
To: Michael Riess <mlriess@gmx.de>
Cc: pgsql-performance@postgresql.org
Subject: Re: Autovacuum / full vacuum
Date: Tue, 17 Jan 2006 16:28:12 -0600
Message-ID: <20060117222812.GG17896@pervasive.com> (raw)
In-Reply-To: <dqj07o$2tl4$1@news.hub.org>
References: <dqigaf$1b98$1@news.hub.org>
<43CCC711.504@familyhealth.com.au>
<dqih4p$1clg$1@news.hub.org>
<m3zmlvq7c9.fsf@mobile.int.cbbrowne.com>
<dqj07o$2tl4$1@news.hub.org>
On Tue, Jan 17, 2006 at 03:50:38PM +0100, Michael Riess wrote:
> Well,
>
> I think that the documentation is not exactly easy to understand. I
> always wondered why there are no examples for common postgresql
> configurations. All I know is that the default configuration seems to be
> too low for production use. And while running postgres I get no hints as
> to which setting needs to be increased to improve performance. I have no
There's a number of sites that have lots of info on postgresql.conf
tuning. Google for 'postgresql.conf tuning' or 'annotated
postgresql.conf'.
> chance to see if my FSM settings are too low other than to run vacuum
> full verbose in psql, pipe the result to a text file and grep for some
> words to get a somewhat comprehensive idea of how much unused space
> there is in my system.
>
> Don't get me wrong - I really like PostgreSQL and it works well in my
> application. But somehow I feel that it might run much better ...
>
> about the FSM: You say that increasing the FSM is fairly cheap - how
> should I know that?
decibel@phonebook.1[16:26]/opt/local/share/postgresql8:3%grep fsm \
postgresql.conf.sample
#max_fsm_pages = 20000 # min max_fsm_relations*16, 6 bytes each
#max_fsm_relations = 1000 # min 100, ~70 bytes each
decibel@phonebook.1[16:26]/opt/local/share/postgresql8:4%
--
Jim C. Nasby, Sr. Engineering Consultant jnasby@pervasive.com
Pervasive Software http://pervasive.com work: 512-231-6117
vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461
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: jnasby@pervasive.com, mlriess@gmx.de
Subject: Re: Autovacuum / full vacuum
In-Reply-To: <20060117222812.GG17896@pervasive.com>
* 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