| From: | Jonathan Vanasco <postgres(at)2xlp(dot)com> |
|---|---|
| To: | David G(dot) Johnston <david(dot)g(dot)johnston(at)gmail(dot)com> |
| Cc: | PostgreSQL mailing lists <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Is it possible to select index values ? |
| Date: | 2016-02-02 22:40:46 |
| Message-ID: | B30697EA-460E-4CAE-B9D7-7D98C5AB6E9F@2xlp.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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 is used. I'm more interested in what the data is.
Basically I want to compare the distribution of index "keys". In the case of a substring index, comparing the distribution at 3,4,5,6,7,8 characters. based on that, i can run some server tests on different lengths, and the stats collector comes into play. i'm taking a blind stab on some index contents, and want to be a bit more educated.
anyways, I eventually realized that I may be better just pulling the columns and running some offline analytics (it could be done in sql, but the results would be nicer as a graph).
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Adrian Klaver | 2016-02-02 22:41:14 | Re: Postgres 9.5 - password for new windows user |
| Previous Message | John R Pierce | 2016-02-02 22:37:58 | Re: Postgres 9.5 - password for new windows user |