Rob Nagler <nagler(at)bivio(dot)biz> 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