From: Tom Lane <tgl@sss.pgh.pa.us>
To: peter royal <peter.royal@pobox.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: help tuning queries on large database
Date: Fri, 06 Jan 2006 18:47:55 -0500
Message-ID: <23743.1136591275@sss.pgh.pa.us> (raw)
In-Reply-To: <FC9B7CC4-F469-4BF5-8862-332E6C26BEA5@pobox.com>
References: <FC9B7CC4-F469-4BF5-8862-332E6C26BEA5@pobox.com>
peter royal <peter.royal@pobox.com> writes:
> So, my question is, is there anything I can do to boost performance
> with what I've got, or am I in a position where the only 'fix' is
> more faster disks? I can't think of any schema/index changes that
> would help, since everything looks pretty optimal from the 'explain
> analyze' output. I'd like to get a 10x improvement when querying from
> the 'cold' state.
I don't think you have any hope of improving the "cold" state much.
The right way to think about this is not to be in the "cold" state.
Check your kernel parameters and make sure it's not set to limit
the amount of memory used for cache (I'm not actually sure if there
is such a limit on Linux, but there definitely is on some other Unixen).
Look around and see if you can reduce the memory used by processes,
or even better, offload non-database tasks to other machines.
Basically you need to get as much of the database as you can to stay
in disk cache.
regards, tom lane
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: tgl@sss.pgh.pa.us, peter.royal@pobox.com
Subject: Re: help tuning queries on large database
In-Reply-To: <23743.1136591275@sss.pgh.pa.us>
* 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