From: Orion Henry <lab@orangekids.org>
To: pgsql-performance@postgresql.org
Subject: Auto performance tuning?
Date: Mon, 20 Mar 2006 11:12:34 -0800
Message-ID: <441EFEA2.70207@orangekids.org> (raw)
I have to say I've been really impressed with the quality and diversity
of tools here to increase performance for PostgreSQL. But I keep seeing
a lot of the same basic things repeated again and again. Has anyone
looked into a "smart" or auto-adjusting resource manager for postgres?
Consider for instance you set it to aggressively use system resources,
then it would do things like notice that it needs more work mem after
profiling a few thousand queries and adds it for you, or that a specific
index or table should be moved to a different spindle and does it in the
background, or that query plans keep screwing up on a particular table
so it knows to up the amount of stastics it keeps on that table.
Is this a crazy idea or something someone's already working on?
Orion
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: lab@orangekids.org
Subject: Re: Auto performance tuning?
In-Reply-To: <441EFEA2.70207@orangekids.org>
* 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