Re: [HACKERS] Postgres optimizer

2007-04-06 Thread Mark Kirkwood
Suresh wrote: Hi, I want to get the coding details regarding postgres optimizer. Essentially, which files correspond to which functions, how the algo is implemented, the flow etc.. Where can I find this material ? Maybe start with the docs, there a good section on optimization: http://www

[HACKERS] Postgres optimizer

2007-04-05 Thread Suresh
Hi, I want to get the coding details regarding postgres optimizer. Essentially, which files correspond to which functions, how the algo is implemented, the flow etc.. Where can I find this material ? Also, how to I start changing Postgres Code using eclipse platform (with tracing, debug fu

[HACKERS] Postgres optimizer, repeated function calls

2005-09-05 Thread Sergey E. Koposov
Hello, I have the following question about the Postgres optimizer. I have two functions: CREATE OR REPLACE FUNCTION test_func(float, OUT a bigint, OUT b bigint) RETURNS record AS 'select test_func1($1)[1],test_func1($1)[2] 'LANGUAGE SQL IMMUTABLE; and CREATE OR REPLACE FUNCTION test_func1