>>>>> "Jonathan" == Jonathan Vanasco <[EMAIL PROTECTED]> writes:
Jonathan> FWIW, i dropped using table inheritance in postgres. the way it was Jonathan> internally handled wasn't fast enough - no matter how i keyed and Jonathan> indexed the tables or tried to influence the optimizer, the internal Jonathan> system always used a slow join I'll second that. I ran arond this block about a half year ago, and have successfully lobbied $client to change his inherited tables into a traditional "main plus variant info" model. Now I just have to do the work. :) -- Randal L. Schwartz - Stonehenge Consulting Services, Inc. - +1 503 777 0095 <[email protected]> <URL:http://www.stonehenge.com/merlyn/> Perl/Unix/security consulting, Technical writing, Comedy, etc. etc. See PerlTraining.Stonehenge.com for onsite and open-enrollment Perl training! ------------------------------------------------------------------------- Using Tomcat but need to do more? Need to support web services, security? Get stuff done quickly with pre-integrated technology to make your job easier. Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642 _______________________________________________ Rose-db-object mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/rose-db-object
