[GENERAL] Strange avg value size for index on expression in pg_stats

2014-11-10 Thread Jehan-Guillaume de Rorthais
Hello, I'm not sure if I should post here or on pgsql-hackers. While investigating about a wrong result with my btree bloat estimation query, I found a strange stat deviation between the average size of a value in its table and its average size in one index on the lower expression. Take the

Re: [GENERAL] Strange avg value size for index on expression in pg_stats

2014-11-10 Thread Jehan-Guillaume de Rorthais
On Mon, 10 Nov 2014 11:52:54 +0100 Jehan-Guillaume de Rorthais iog...@free.fr wrote: Hello, I'm not sure if I should post here or on pgsql-hackers. While investigating about a wrong result with my btree bloat estimation query, I found a strange stat deviation between the average size of a

Re: [GENERAL] Strange avg value size for index on expression in pg_stats

2014-11-10 Thread Tom Lane
Jehan-Guillaume de Rorthais iog...@free.fr writes: While investigating about a wrong result with my btree bloat estimation query, I found a strange stat deviation between the average size of a value in its table and its average size in one index on the lower expression. ANALYZE doesn't look at

Re: [GENERAL] Strange avg value size for index on expression in pg_stats

2014-11-10 Thread Jehan-Guillaume de Rorthais
On Mon, 10 Nov 2014 09:39:23 -0500 Tom Lane t...@sss.pgh.pa.us wrote: Jehan-Guillaume de Rorthais iog...@free.fr writes: While investigating about a wrong result with my btree bloat estimation query, I found a strange stat deviation between the average size of a value in its table and its