From: Robert Treat <xzilla@users.sourceforge.net>
To: amrit@health2.moph.go.th
Cc: pg@fastcrypt.com, PGsql-performance <pgsql-performance@postgresql.org>
Subject: Re: Low Performance for big hospital server ..
Date: Mon, 3 Jan 2005 13:51:55 -0500
Message-ID: <200501031351.55065.xzilla@users.sourceforge.net> (raw)
In-Reply-To: <1104766805.41d96755a40d9@webmail.moph.go.th>
References: <1104634472.41d762681b548@webmail.moph.go.th>
<41D9525D.3000409@fastcrypt.com>
<1104766805.41d96755a40d9@webmail.moph.go.th>
On Monday 03 January 2005 10:40, amrit@health2.moph.go.th wrote:
> > I realize you may be stuck with 7.3.x but you should be aware that 7.4
> > is considerably faster, and 8.0 appears to be even faster yet.
>
> There are a little bit incompatibility between 7.3 -8 , so rather difficult
> to change.
>
Sure, but even moving to 7.4 would be a bonus, especially if you use a lot of
select * from tab where id in (select ... ) type queries, and the
incompataibility is less as well.
> > I would seriously consider upgrading, if at all possible.
> >
> > A few more hints.
> >
One thing I didn't see mentioned that should have been was to watch for index
bloat, which was a real problem on 7.3 machines. You can determine which
indexes are bloated by studying vacuum output or by comparing index size on
disk to table size on disk.
Another thing I didn't see mentioned was to your free space map settings.
Make sure these are large enough to hold your data... max_fsm_relations
should be larger then the total # of tables you have in your system (check
the archives for the exact query needed) and max_fsm_pages needs to be big
enough to hold all of the pages you use in a day... this is hard to calculate
in 7.3, but if you look at your vacuum output and add the number of pages
cleaned up for all tables, this could give you a good number to work with. It
would certainly tell you if your setting is too small.
--
Robert Treat
Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL
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: xzilla@users.sourceforge.net, amrit@health2.moph.go.th
Subject: Re: Low Performance for big hospital server ..
In-Reply-To: <200501031351.55065.xzilla@users.sourceforge.net>
* 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