Re: [GENERAL] pg_stats in 9.2

2012-10-18 Thread Guillaume Lelarge
On Wed, 2012-10-17 at 11:57 -0400, Tom Lane wrote: > Guillaume Lelarge writes: > > Anyone care to explain all this to me? :) > > Try the stats-slot type specifications in > src/include/catalog/pg_statistic.h > Oh, OK, got it. The three more values are, in order, the smaller frequency, the bigg

Re: [GENERAL] pg_stats in 9.2

2012-10-17 Thread Tom Lane
Guillaume Lelarge writes: > Anyone care to explain all this to me? :) Try the stats-slot type specifications in src/include/catalog/pg_statistic.h regards, tom lane -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscripti

[GENERAL] pg_stats in 9.2

2012-10-17 Thread Guillaume Lelarge
Hi, I try to understand the new columns in pg_stats in 9.2, but I'm kinda puzzled by the results. Here is the test case I'm working on: CREATE TABLE t1(c1 integer, c2 integer[]); INSERT INTO t1 select 1, '{4}'; INSERT INTO t1 select 2, '{5}'; INSERT INTO t1 select 3, '{6}'; ANALYZE t1; SELECT *