Greenplum patch for estimated rowcounts being wrong.

Поиск
Список
Период
Сортировка
От Chuck McDevitt
Тема Greenplum patch for estimated rowcounts being wrong.
Дата
Msg-id 2106D8DC89010842BABA5CD03FEA4061B86B2AAD@EXVMBX018-10.exch018.msoutlookonline.net
обсуждение исходный текст
Ответ на Re: Debugger hung on dummy function  (Dave Page <dpage@pgadmin.org>)
Ответы Re: Greenplum patch for estimated rowcounts being wrong.  (Dave Page <dpage@pgadmin.org>)
Список pgadmin-hackers
Greenplum stores the number of rows per segmentDatabase (actually the max of any of the segDBs) in pg_class.reltuples,
notthe total number of tuples. 

This causes the stats to display wrong values, and causes pgAdmin to warn that Analyze is needed when it is not.

This simple patch multiplies the reltuples x gp_segments, so that we get a better value.

Of course, it only does this for Greenplum connections.



Вложения

В списке pgadmin-hackers по дате отправления:

Предыдущее
От: svn@pgadmin.org
Дата:
Сообщение: SVN Commit by dpage: r7806 - trunk/pgadmin3/pgadmin/debugger
Следующее
От: svn@pgadmin.org
Дата:
Сообщение: SVN Commit by dpage: r7807 - trunk/pgadmin3/pgadmin/schema