[HACKERS] enforcing a join type

Hi, If I want the planner/optimizer to always choose merge join when it needs to join relations. How can I do it ? Thanks, --h ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster

Re: [HACKERS] enforcing a join type

lto:[EMAIL PROTECTED] Sent: Wednesday, August 04, 2004 5:41 PM To: Hicham G. Elmongui Cc: [EMAIL PROTECTED] Subject: Re: [HACKERS] enforcing a join type On Wed, 2004-08-04 at 14:53, Hicham G. Elmongui wrote: > Hi, > If I want the planner/optimizer to always choose merge join when it needs to

Re: [HACKERS] enforcing a join type

is is still the wrong place for this question. --h -Original Message- From: Scott Marlowe [mailto:[EMAIL PROTECTED] Sent: Wednesday, August 04, 2004 6:42 PM To: Hicham G. Elmongui Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: Re: [HACKERS] enforcing a join type As this is not really

[HACKERS] OidFunctionCall4

In "join_selectivity" function (plancat.c), a function call is made to "OidFunctionCall4" (fmgr.c), which in turn calls a function pointer. In need to know what is the actual function being called from OidFunctionCall4 if the selectivity of mergejoin is the one required from join_selectivity. Tha

[HACKERS] error in linking

Hi, i am trying to add some functions to postgresql. I created a file called "./src/backend/executor/testing.c" then created a file called "./src/include/executor/testing.h" then added "testing.o" to the OBJS in "./src/backend/executor/Makefile" I included "executor/testing.h" in execM

[HACKERS] am i asking in the wrong place?

, --h On Thu, 5 Aug 2004, Hicham G. Elmongui wrote: > In "join_selectivity" function (plancat.c), a function call is made to > "OidFunctionCall4" (fmgr.c), which in turn calls a function pointer. > > In need to know what is the actual function being called from >

[HACKERS] pulling projection up in plans

Hi, is there a way to pull the projection operator to the top of the query plan? I wish there's a variable that can be set to do so. Thanks, --h ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.pos

Re: [HACKERS] pulling projection up in plans

PROTECTED]> writes: > > Tom> "Hicham G. Elmongui" <[EMAIL PROTECTED]> writes: > >> is there a way to pull the projection operator to the top of > >> the query plan? I wish there's a variable that can be set to do > >> so

[HACKERS] printing HeapTuple

Is there an existing function that I can use to print the "HeapTuple" return value of "ExecScanHashBucket" in nodeHash.c? Thanks, --h ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org

[HACKERS] planner & target lists

Hi, I am confused about an internal point of the planner. Consider a select query and the output target list at the root of the tree. This target lists points to some Vars. Each of which has as relation either INNER/OUTER. Does this INNER/OUTER refer to the inner/outer relations of the top-most no

[HACKERS] modifying a TupleTableSlot

If I have a TupleTableSlot, and I need to obtain another TupleTableSlot with a different TupleDesc (same fields but different order). Is there a way to do it without that I go myself and try to retrieve the fields and form the tuple myself? In other words, are there functions already in postgres th

[HACKERS] enforcing a plan

I am doing an experiment in which I need the following: SET enable_mergejoin = false; SET enable_hashjoin = false; SELECT ... FROM tab00 as T00, tab01 as T01, tab02 as T02, tab03 as T03 WHERE T00.id = T01.id AND T00.id = T02.id AND T00.id = T03.id LIMIT 51; There's an index on each primary k

[HACKERS] enforcing a plan (in brief)

Is there a way to bypass the optimizer and to specify a plan to be executed? Something like: Limit -> Nested Loop -> Nested Loop -> Seq Scan on tab00 t00 -> Index Scan using tab03_pkey on tab03 t03 Index Cond: ("outer".id = t03.id) -> Index Sca