Re: [HACKERS] Want to use my own query-plan

2006-10-21 Thread Alvaro Herrera
dakotali kasap wrote: > Therefore, I want to say the join-method that > will be used or which relation will be outer which one will be inner. > (I cannot do this just using SELECT * FROM a JOIN b). You can't force the system to use a particular join method, but you can select which one is inner

Re: [HACKERS] Want to use my own query-plan

2006-10-21 Thread dakotali kasap
Actually, the system that we want to build up will keep incomplete information with a decomposition based approach. So a normal relation R will be represented on 3 different relations (T:template, C: components, W:worlds). According to this representation a normal selection with constant on R will

Re: [HACKERS] Want to use my own query-plan

2006-10-20 Thread Neil Conway
On Fri, 2006-10-20 at 16:05 -0700, dakotali kasap wrote: > 1. How can I prepare my own query plan? You can't: there is currently no public API for constructing plans by hand. You could kludge something up by hand, but it would be pretty fragile (internal planner data structures may well change bet

[HACKERS] Want to use my own query-plan

2006-10-20 Thread dakotali kasap
Hi everybody,I have started to work on a project that will be implemented on top of Postgresql. Therefore, I have to warm up with postgresql's internals. I downloaded the source code and currently looking at it. But I have some questions?1. How can I prepare my own query plan? (I will need this bec