Re: [HACKERS] Statistic Estimation in PostgreSQL

2008-10-15 Thread Jan Urbański
rahulg wrote: I am facing problem in tracing in what events the selectivity histogram in pg_statistic is stored/updated. I went through the code in src/backend/commands/analyze.c and got to see the code computing the histogram but when I tried to trace the caller of analyze_rel or compute_index_

Re: [HACKERS] Statistic Estimation in PostgreSQL

2008-10-15 Thread Alvaro Herrera
rahulg escribió: > > Can anybody tell me in what all events is the pg_statistic table > exactly updated? only ANALYZE -- Alvaro Herrerahttp://www.CommandPrompt.com/ The PostgreSQL Company - Command Prompt, Inc. -- Sent via pgsql-hackers mailing list (pgsql-hac

[HACKERS] Statistic Estimation in PostgreSQL

2008-10-15 Thread rahulg
I am facing problem in tracing in what events the selectivity histogram in pg_statistic is stored/updated. I went through the code in src/backend/commands/analyze.c and got to see the code computing the histogram but when I tried to trace the caller of analyze_rel or compute_index_stats, I find ou