Home > mailing lists

Re: Odd behavior with indices - Mailing list pgsql-performance

From	David G. Johnston
Subject	Re: Odd behavior with indices
Date	February 26, 2016 23:56:25
Msg-id	CAKFQuwaPpvfyHHUdZdkJoSGhMcC4GkOPcb55sgEdvMkkw94M4w@mail.gmail.com Whole thread Raw
In response to	Re: Odd behavior with indices (joe meiring <josephmeiring@gmail.com>)
List	pgsql-performance

Tree view

On Fri, Feb 26, 2016 at 1:38 PM, joe meiring <josephmeiring@gmail.com> wrote:

Here's the distribution of parameter_id's

select count(parameter_id), parameter_id from datavalue group by parameter_id

88169   14
2889171 8
15805   17
8570    12
4257262 21
3947049 15
1225902 2
4091090 3
103877  10
633764  11
994442  18
49232   20
14935   4
563638  13
2955919 7

Ok...again its beyond my present experience but its what the planner thinks about the distribution, and not what actually is present, that matters.

David J.

pgsql-performance by date:

From: joe meiring
Date: 26 February 2016, 23:38:15
Subject: Re: Odd behavior with indices

From: James Parks
Date: 27 February 2016, 01:08:07
Subject: Merge joins on index scans

Re: Odd behavior with indices - Mailing list pgsql-performance

Previous

Next