Re: [PERFORM] encouraging index-only scans - Mailing list pgsql-hackers

From Hannu Krosing
Subject Re: [PERFORM] encouraging index-only scans
Date
Msg-id 5229BED0.5070506@2ndQuadrant.com
Whole thread Raw
In response to Re: [PERFORM] encouraging index-only scans  (Dimitri Fontaine <dimitri@2ndQuadrant.fr>)
Responses Re: [PERFORM] encouraging index-only scans
List pgsql-hackers
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Ü




pgsql-hackers by date:

Previous
From: Greg Stark
Date:
Subject: Re: Analysis on backend-private memory usage (and a patch)
Next
From: Agustin Larreinegabe
Date:
Subject: