Re: Stats for inheritance trees - Mailing list pgsql-hackers

From Robert Haas
Subject Re: Stats for inheritance trees
Date
Msg-id 603c8f071001051018o618b12ccw593123fd3d474c56@mail.gmail.com
Whole thread Raw
In response to Re: Stats for inheritance trees  (Robert Haas <robertmhaas@gmail.com>)
Responses Re: Stats for inheritance trees  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
On Tue, Jan 5, 2010 at 1:09 PM, Robert Haas <robertmhaas@gmail.com> wrote:
> On Tue, Jan 5, 2010 at 1:00 PM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
>> Robert Haas <robertmhaas@gmail.com> writes:
>>> Another option would be to call it "inherits_ndistinct", or something
>>> like that, which seems a little more readable, but not great: I don't
>>> think there's going to be any getting around the need to RTFM before
>>> setting these parameters.
>>
>> Well, the previously agreed-to syntax was SET STATISTICS DISTINCT.
>> I don't see a problem with using "distinct" and "inherited_distinct"
>> or something like that.  "ndistinct" is probably not a good name to
>> expose to non-programmers.
>
> I like ndistinct because it makes the whole thing sound related to
> statistics, which it is.  But I'll do it your way unless there are
> other votes.

It's probably also worth noting that the reason I used DISTINCT
originally is because it's already a keyword.   That's a moot point
here.  But as I say I'll stick with your names unless there are
contravening votes.

...Robert


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: Re: [COMMITTERS] pgsql: Get rid of the need for manual maintenance of the initial
Next
From: Tom Lane
Date:
Subject: Re: Stats for inheritance trees