From: Simon Riggs <simon@2ndquadrant.com>
To: List pgsql-patches <pgsql-patches@postgresql.org>
Subject: WIP: Transportable Optimizer Mode
Date: Fri, 25 Jul 2008 22:58:27 +0100
Message-ID: <1217023107.3894.1053.camel@ebony.2ndQuadrant> (raw)
I've written a contrib module that allows planning information to be
extracted from one server and transported to another server to allow SQL
analysis: Transportable Optimizer Mode (TOM).
TOM works, yet is incomplete because of the lack of a stats hook within
the server. So TOM is the application which would seek to use the recent
patch requesting stats hooks in Postgres.
I'm posting this as background to later patches that will
* re-introduce a stats hook
* complete TOM so that it works fully with the stats hook
That way we can all see where I'm going with this, and why, as well as
providing a test harness for the stats hook patches.
The main purpose of all of this is to literally "get data for Tom" -
enhance the ability of experts to diagnose SQL query plans without
requiring access to the data on remote servers. I see this as an
enabling tool that will provide more information about optimizer issues
and opportunities.
Comments welcome.
--
Simon Riggs www.2ndQuadrant.com
PostgreSQL Training, Services and Support
Attachments:
TOM.tar (application/x-tar, 20.0K) download
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-patches@postgresql.org
Cc: simon@2ndquadrant.com
Subject: Re: WIP: Transportable Optimizer Mode
In-Reply-To: <1217023107.3894.1053.camel@ebony.2ndQuadrant>
* 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