[GENERAL] query optimizer

Hello, As I see the documentation of postgres, postgres use genetic algorithm for query optimization rather than system R optimizer. right? -- Jungmin Shin

[GENERAL] meaning of Total runtime

Could you somebody explain to me what is the meaning of Total runtime which is generated by explain analyze command? Thanks, Jungmin -- Jungmin Shin

[GENERAL] turn off cache option

ms or 11688ms . There is huge differences. If a cache is used for this execution , can I turn off the cache option? Thanks, -- Jungmin Shin

Re: [GENERAL] Why *exactly* is date_trunc() not immutable ?

I have a question about the query optimizer of a postgres. As long as I understood through a postgres manual, the postgres query optimizer is implemented using a *genetic algorithm.* I'm thinking to modify the query optimizer. Are there any postgres version which uses typical dynamic programming

Re: [GENERAL] Invoking java in a trigger

--- TIP 1: if posting/reading through Usenet, please send an appropriate   subscribe-nomail command to [EMAIL PROTECTED] so that your   message can get through to the mailing list cleanly -- Jungmin Shin

[GENERAL] UDF and cache

t how postgres is maintaing the cache of UDFs.   Thanks, Jungmin -- Jungmin Shin

[GENERAL] query optimization with UDFs

      Hello  Everybody,   I have a question about optimization of queries which includes UDFs. Does anybody know what the Postgres does for optimizing the queries with UDFs? Does the Postgres query optimizer do anything special with UDFs?   Thanks, Jungmin Shin