[PERFORM] GIST optimization to limit calls to operator on sub nodes

2014-06-23 Thread Pujol Mathieu
Hello, I already post my question in the General Mailing list, but without succeed so I try this one that seems to me more specialized. My question is about GIST index. I made my own index to handle specific data and operators. It works pretty fine but I wonder if it was possible to optimize it

[PERFORM] Re: autovacuum vacuum creates bad statistics for planner when it log index scans: 0

2014-06-23 Thread tim_wilson
Have been looking at lazyvacuum.c trying to think of a way of changing the calculation of the stats to ensure that my hot table stats do not get so badly distorted. What I have noticed is that when I reindex my hot table the stats on the table do not seem to change in pg_stat_user_tables (ie they