Re: add_path optimization - Mailing list pgsql-hackers

From David Fetter
Subject Re: add_path optimization
Date
Msg-id 20090201170343.GJ17601@fetter.org
Whole thread Raw
In response to add_path optimization  (Robert Haas <robertmhaas@gmail.com>)
Responses Re: add_path optimization  (Robert Haas <robertmhaas@gmail.com>)
List 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 by date:

Previous
From: Grzegorz Jaskiewicz
Date:
Subject: Re: Updated backslash consistency patch
Next
From: Robert Haas
Date:
Subject: Re: add_path optimization