Re: add_path optimization

Поиск
Список
Период
Сортировка
От David Fetter
Тема Re: add_path optimization
Дата
Msg-id 20090201170343.GJ17601@fetter.org
обсуждение исходный текст
Ответ на add_path optimization  (Robert Haas <robertmhaas@gmail.com>)
Ответы Re: add_path optimization
Список pgsql-hackers
On Sat, Jan 31, 2009 at 11:37:39PM -0500, Robert Haas wrote:
> I've been doing some benchmarking and profiling on the PostgreSQL
> query analyzer, and it seems that (at least for the sorts of queries
> that I typically run) the dominant cost is add_path().  I've been
> able to find two optimizations that seem to help significantly:

Are there any cases you've found where this change significantly
impairs performance, and if so, how did you find them?  If not, would
you be up for trying to find some?

Cheers,
David.
-- 
David Fetter <david@fetter.org> http://fetter.org/
Phone: +1 415 235 3778  AIM: dfetter666  Yahoo!: dfetter
Skype: davidfetter      XMPP: david.fetter@gmail.com

Remember to vote!
Consider donating to Postgres: http://www.postgresql.org/about/donate


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

Предыдущее
От: Grzegorz Jaskiewicz
Дата:
Сообщение: Re: Updated backslash consistency patch
Следующее
От: Robert Haas
Дата:
Сообщение: Re: add_path optimization