Message-ID: <5229BED0.5070506@2ndQuadrant.com>
Date: Fri, 06 Sep 2013 13:38:56 +0200
From: Hannu Krosing <hannu@2ndQuadrant.com>
Organization: 2ndQuadrant Nordic =?ISO-8859-1?Q?O=DC?=
User-Agent: Mozilla/5.0 (X11; Linux x86_64;
 rv:17.0) Gecko/20130804 Thunderbird/17.0.8
MIME-Version: 1.0
To: Dimitri Fontaine <dimitri@2ndQuadrant.fr>
CC: Alvaro Herrera <alvherre@2ndquadrant.com>,
 Bruce Momjian <bruce@momjian.us>, Robert Haas <robertmhaas@gmail.com>,
 Peter Geoghegan <peter@2ndquadrant.com>,
 Tom Lane <tgl@sss.pgh.pa.us>, Andrew Dunstan <andrew@dunslane.net>,
 PostgreSQL-development <pgsql-hackers@postgresql.org>
Subject: Re: [PERFORM] encouraging index-only scans
References: <15321.1355347953@sss.pgh.pa.us> <50C90154.8060103@dunslane.net>
 <50C904DB.9090305@dunslane.net> <20121213024837.GB22363@momjian.us>
 <23298.1355370698@sss.pgh.pa.us>
 <CAEYLb_U1dTg=bXkDL=yvFTrMw5oC13ivgZA=jdQXnbgaDJ+e-Q@mail.gmail.com>
 <20130904205655.GR21874@momjian.us> <20130906001437.GA29264@momjian.us>
 <CA+Tgmobh_-n-GvKX++DVctToZ9SZkdhvszP=CBjh9XZOvWsTEg@mail.gmail.com>
 <20130906020043.GH27195@momjian.us>
 <20130906052236.GF6067@eldon.alvh.no-ip.org> <m28uza5s7w.fsf@2ndQuadrant.fr>
In-Reply-To: <m28uza5s7w.fsf@2ndQuadrant.fr>
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 8bit
Precedence: bulk
Sender: pgsql-hackers-owner@postgresql.org

On 09/06/2013 09:23 AM, Dimitri Fontaine wrote:
> Alvaro Herrera <alvherre@2ndquadrant.com> writes:
>> I'm not sure if we need to expose all these new maintenance actions as
>> SQL commands.
> I strongly think we should, if only for diagnostic purposes. 
It would be much easier and more flexible to expose them
as pg_*() function calls, not proper "commands".
> Also to
> adapt to some well defined workloads that the automatic system is not
> designed to handle.
+1

-- 
Hannu Krosing
PostgreSQL Consultant
Performance, Scalability and High Availability
2ndQuadrant Nordic OÜ


-- 
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers