Weird. I wonder if the attachment is too big and the mailing list server is chopping it off of the email. On Fri, Jan 16, 2009 at 1:19 PM, Jason Long <mailing.list@xxxxxxxxxxxxxxxxxxxxx> wrote: > Scott Marlowe wrote: > > On Thu, Jan 15, 2009 at 11:04 PM, Jeff Davis <pgsql@xxxxxxxxxxx> wrote: > > > On Thu, 2009-01-15 at 19:37 -0600, Jason Long wrote: > > > I have not looked into the detail of the explain, and I do see visually > that very different plans are being chosen. > > > > It would help to share these plans with us... > > > > See EXPLAIN ANALYZE below for three different plans @ .5, 6, and 84 > seconds > > > Jason, note that the post with explain analyze didn't make it to the > mailing list, so you're effectively leaving everyone else who could > give you advice out of the conversation. > > > I just sent it again. I wonder why it did not make it. Hopefully this one > will. Please let me know if this one does not either. > -- When fascism comes to America, it will be draped in a flag and carrying a cross - Sinclair Lewis -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general