Re: Stats for inheritance trees

From: Robert Haas <robertmhaas(at)gmail(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: Stats for inheritance trees
Date: 2010-01-05 18:22:28
Message-ID: 603c8f071001051022x9224d3j5558344c83b8af01@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Tue, Jan 5, 2010 at 1:20 PM, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
> Robert Haas <robertmhaas(at)gmail(dot)com> writes:
>> It's probably also worth noting that the reason I used DISTINCT
>> originally is because it's already a keyword.
>
> True.
>
> It occurs to me that the pg_stats view already exposes "n_distinct"
> as a column name.  I wouldn't object to using "n_distinct" and
> "n_distinct_inherited" or some such.

OK. So we have:

1. distinct and inherited_distinct, or
2. n_distinct and n_distinct_inherited

Any other votes/thoughts/opinions/color commentary?

...Robert

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Merlin Moncure 2010-01-05 18:26:26 Re: Proposal: XML helper functions
Previous Message Tom Lane 2010-01-05 18:20:11 Re: Stats for inheritance trees