At 09:58 PM 11/28/02 -0500, you wrote: >Hm. Are we sure that both versions were built with the same >optimization level, etc? (My private bet is that Wade's 7.2 didn't >have multibyte or locale support --- but that's a long shot when we >don't know the datatypes of the columns being joined on...) > >> Also, is it expected that the cardinality estimates for join steps won't >> be very accurate, right? (estimated: 19 rows, actual: 765 rows) OK, I've updated the link http://arch.wavefire.com/72v73a.txt to include the table schema for those involved in the query. As far as locale suport et al, I can tell you that both are built using a straigh, out-of-the-box ./configure. > >Well, it'd be nice to do better --- I was hoping Wade would look into >why the row estimates were off so much. I'd love to :). But where to start? Can you point me at a thread where a similar procedure was explained to someone else? -Wade > > regards, tom lane > >---------------------------(end of broadcast)--------------------------- >TIP 4: Don't 'kill -9' the postmaster > >
---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
