Re: -HEAD planner issue wrt hash_joins on dbt3 ?

Поиск
Список
Период
Сортировка
От Matteo Beccati
Тема Re: -HEAD planner issue wrt hash_joins on dbt3 ?
Дата
Msg-id 4511CDE8.2000400@beccati.com
обсуждение исходный текст
Ответ на Re: -HEAD planner issue wrt hash_joins on dbt3 ?  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers
Hi,

Tom Lane wrote:
> I've committed this change with (for now) 100 as the minimum histogram
> size to use.  Stefan, are you interested in retrying your benchmark?

A first try with ltree gave big improvements on my smaller data set: the 
estimated row count is correct or off by only 1 row. I'm now restoring a 
bigger database to get more reliable results.

I hope Stefan can confirm the improvement on dbt3 too.

Thanks Tom :)


Best regards
--
Matteo Beccati
http://phpadsnew.com
http://phppgads.com


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

Предыдущее
От: Gevik Babakhani
Дата:
Сообщение: Re: TODO: Fix CREATE CAST on DOMAINs
Следующее
От: Bruce Momjian
Дата:
Сообщение: Re: Release notes