On Sat, 2007-10-27 at 17:48 -0400, Luke Lonergan wrote: > Works great - plans no longer sort, but rather use indices as > expected. It's in use in Greenplum now. > > It's a simple approach, should easily extend from gpdb to postgres. > The patch is against gpdb so someone needs to 'port' it. The part of the patch that didn't work for me was the nrels==1 bit. The way it currently works there is only ever 0 or 2+ rels. The normal Postgres code has to cater for the possibility of a non-empty parent table, which seems to destroy the possibility of using this technique. I agree its annoying and I have a way of doing this, but that's an 8.4 thing now. Anybody think different? -- Simon Riggs 2ndQuadrant http://www.2ndQuadrant.com ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings
