On Wed, Apr 15, 2009 at 1:25 PM, Simon Riggs <simon@xxxxxxxxxxxxxxx> wrote: > The cost of the query seems accurate, so the absence of > attachment_isins_attachment_idx on the 8.3 plan looks to be the reason. > There's no way it would choose to scan 8115133 rows on the pkey if the > other index was available and usable. hance my question, if there's index on it in 8.3 version of db. -- GJ -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
