On Wed, Dec 13, 2006 at 02:08:44PM -0500, Tom Lane wrote: > Are you on 8.2? 8.1 is pretty stupid about joins to inheritance trees.
To put up a number for "stupid": For GNUmed a particular query involving one-level inheritance went down from over ten minutes to under one second just by running against 8.2 instead of below 8.2. Karsten -- GPG key ID E4071346 @ wwwkeys.pgp.net E167 67FD A291 2BEA 73BD 4537 78B9 A9F9 E407 1346 ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings
