Rob Nagler <[EMAIL PROTECTED]> writes: > q5 and q6 are too complex to discuss here,
How do you expect us to get better if you don't show us the problems? BTW, have you tried any of this with a 7.4beta release? Another project that I'm aware of saw several bottlenecks in their Oracle-centric code go away when they tested 7.4 instead of 7.3. For instance, there is hash aggregation capability, which would probably solve the aggregate query problem you were complaining about in http://archives.postgresql.org/pgsql-performance/2003-10/msg00640.php regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend
