Re: [PERFORM] Logarithmic data frequency distributions and the query planner

2010-07-07 Thread Tom Lane
Jerry Gamache writes: > On 8.1, I have a very interesting database where the distributions of > some values in a multi-million rows table is logarithmic (i.e. the most > frequent value is an order of magnitude more frequent than the next > ones). If I analyze the table, the statistics become ex

[PERFORM] Logarithmic data frequency distributions and the query planner

2010-07-07 Thread Jerry Gamache
On 8.1, I have a very interesting database where the distributions of some values in a multi-million rows table is logarithmic (i.e. the most frequent value is an order of magnitude more frequent than the next ones). If I analyze the table, the statistics become extremely skewed towards the mos