Mohan, Ross wrote:
1) Many (many!) uninitialized variables in code. Optimizers don't do well with this.
Um, what?
2) Not clear (to me, a nonprogrammer) whether this is GNU C, ANSI C, "Postgres" C, or what the overall coding protocol is.
Postgres is mostly ANSI C89, with limited use of GNU C extensions (which should be limited to inside #ifdef __GNUC__ blocks, AFAIK).
-Neil ---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend