Re: [GENERAL] Is it possible to select index values ?

2016-02-02 Thread Melvin Davidson
Have you given any thought to pulling index column stats from the pg_stats view? -- *Melvin Davidson* I reserve the right to fantasize. Whether or not you wish to share my fantasy is entirely up to you.

Re: [GENERAL] Is it possible to select index values ?

2016-02-02 Thread Jonathan Vanasco
On Feb 1, 2016, at 6:58 PM, David G. Johnston wrote: > You can query the statistics portion of the database to get some basic > statistics of the form mentioned. Yeah, i didn't think there would be support. The stats collector doesn't have the info that I want... it's focused on how the data

Re: [GENERAL] Is it possible to select index values ?

2016-02-01 Thread David G. Johnston
On Mon, Feb 1, 2016 at 4:29 PM, Jonathan Vanasco wrote: > Is it possible to select index values ? > > I haven't found any documentation that says "No", but I haven't found > anything that says "Yes" either. > > The reason - I have a few function indexes that are working as partial > indexes. I'd

[GENERAL] Is it possible to select index values ?

2016-02-01 Thread Jonathan Vanasco
Is it possible to select index values ? I haven't found any documentation that says "No", but I haven't found anything that says "Yes" either. The reason - I have a few function indexes that are working as partial indexes. I'd like to run some analytics on them (to determine uniqueness of valu