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 wrote: > Jehan-Guillaume de Rorthais 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

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

2014-11-10 Thread Tom Lane
Jehan-Guillaume de Rorthais 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 the physi

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 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 value in

[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 fo