Re: [HACKERS] Re: Any optimizations to the join code in 7.1?

2001-04-30 Thread Tom Lane
Thomas Lockhart <[EMAIL PROTECTED]> writes: > But it is possible, under many circumstances, for query optimization to > be a benefit for a many-table query. The docs indicate that explicit > join syntax bypasses that, even for inner joins, so you may find that > this syntax is a net loss in perfor

RE: [HACKERS] Re: Any optimizations to the join code in 7.1?

2001-04-27 Thread Mike Mascari
What would be nice, and I don't know how it would be done or what the syntax would be, would be a feature that allows PostgreSQL to skip not only the parsing stage, but the planning stage as well. Then, when the data has changed dramatically enough to warrant it, as you point out, a command ca